| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> i undeerstanded that bind-address = 127.0.0.1 it's like skip-networking
<0> so i commented it
<0> and i read it in several mysql-help sites
<1> well... I'd change it to your external IP address. but tell me what's the error, as it got cut
<0> yango: what do you mean ?
<1> zyv, what do I mean with what?
<1> bind_address = 200.43.53.99 <= external IP of mysql host
<0> sorry for my english: i dont understand what you say, can you explain it
<1> and show the error
<1> the thing you wrote ended like The error in client side its: "ERROR 1130 (00000): Host '84-122-114-177.onocable.ono.co
<1> without showing the error
<0> do you say that i must change bind-address = 127.0.0.1 (the default in my.cnf) for bind-address = the_external_ip_address
<1> zyv, yes, BUT SHOW ME THE ERROR FIRST
<0> error in client side ?
<1> yes
<0> that's the error !: "ERROR 1130 (00000): Host '84-122-114-177.onocable.ono.com' is not allowed to connect to this MySQL server"
<0> 84-122-114-177.onocable.ono.com it's my client host
<1> zyv, then that's not the solution
<0> aha
<1> (modifying bind_address)
<2> !m zyv adding new user
<3> zyv: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<0> yeah i understand
<0> will: i created the user and flush privileges with: "GRANT ALL on test.* TO 'myUser'@'%' IDENTIFIED BY 'oneP***word'"
<0> then flush privileges
<0> yango: what's the solution then ?
<4> i install mysql 5.0 with the binaries, all goes well, i can create tables n stuff, but when i try to install mysqltcl, it asks for a libmysqlclient.so , but there isnt any. Do I only get this if I compile it myself?
<4> and hi btw
<4> mysql-max-5.0.19-linux
<1> zyv, don't know... try explicitly setting the host... manually editing mysql.user table... restarting the server... I always do that when it fails for me... what hasn't failed is using phpmyadmin :) it always creates them alright
<0> yango i tried to specify the host un mysql.user table instead '%'
<0> same result
<5> Hi guys ... so I have a simple table layout here
<6> hi
<5> Personal: name, email (primary), organization
<5> Email: send_to_email, send_to_name (both non-unique)
<5> Key: email (primary) KEY_VALUE
<6> is there a way to CONSTRAINT a field to be unique over more than One Table
<5> So I'll need my KEY_VALUE to be a unique value to link from Email to Personal ...
<5> marmoute: not really sure to be honest ...
<7> can a foreign key have the same name as the primary key that it points to?
<6> (I've got three Table USER GROUPE and ADMIN all of them as a Login fields
<8> is "SHOW COLUMNS ".$table any different from "DESCRIBE ".$table at all?
<8> "SHOW COLUMNS FROM ".$table - bad syntax before, sorry
<6> does mysql support view ?
<9> [fields]: aliases
<8> found my answer: DESCRIBE provides information about the columns in a table. It is a shortcut for SHOW COLUMNS FROM.
<8> thanks flupps
<9> SHOW FULL COLUMNS... will display some extra stuff, though
<8> really?
<8> flupps: Nice. thank you.
<8> how can I export the structure of a table like I often do in PHPMYADMIN?
<10> !m [fields] mysqldump
<3> [fields]: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<4> hey, do i need to compile mysql from source to get libmysqlclient.so ?
<4> as when i download the binaries it's not in there :)
<11> I have a text field in form of "First M. Last (my@email.com", how do I use order by to aplphabetically list out "Last"?
<11> I can't spell :(
<8> chandra: some string functions I would imagine
<8> CONCAT() perhaps?
<11> ok
<8> probably not CONCAT, but some other string functions
<2> Chandra, You don't.
<2> You need to separate out the data.
<11> :((
<2> You MIGHT be able to automate as much of that as possible by cleaning up the data. Make sure everything is consistant. Like ensureing that everyone (or no one ) has a middle name.
<12> hi. I hava a quick question: I'm in database 1 and want to SELECT FROM TABLE in database 2. How is the syntax?
<2> Put db2 before your table names
<8> Chandra: I would think its possible to do it.
<2> SELECT db2.table2.col2 FROM db2.table2
<2> Therion, I watched Ice Age last night. Though of you.
<12> thanks
<13> I'm trying to make a select list in a form and I'm missing something...
<13> I'm not quite sure what the first parameter corresponds to
<14> like the right channel to discuss HTML in ?
<2> heh
<15> troll alert!
<2> Ok I'll leave
<16> /me creeps out from under a stone
<13> Whoops... wrong channel
<17> how trustworthy is select_last_insert_id()
<17> err last_insert_id()
<14> like a blonde on prom night
<17> so not very?
<14> depends, if you wanna get laid.. very
<14> but only if you're her date
<17> well; what I mean is I need to be pretty much 100% sure that the id I am manipulating is the last thing that was inserted
<2> !m DogWater last insert id
<3> DogWater: (How to Get the Unique ID for the Last Inserted Row) : http://dev.mysql.com/doc/mysql/en/Getting_unique_ID.html
<17> right; I know how to get the last insert id, i am just trying to ascertain whether or not it is reliable
<18> DogWater: it is
<2> I believe that doc states it.
<18> DogWater: last_insert_id() returns the last insert id your connection inserted
<14> if you're her date.. you should be pretty certain that you were the last one that inserted anything.. but if you were to leave her alone with a few football players.. and come back.. your last_insert_id may not be.. trust worthy
<18> DogWater: but dunno what happend when your connection is closed between insert and last_insert_id
<14> see my analogy on blondes, prom night and football players
<2> I don't know of any MySQL function that is not "trustworthy"....
<17> if you insert something, and then immediately insert something else using the last_insert_id() as a value for the second insert; i'm trying to figure out the chances of it being wrong
<2> err
<17> will: well, i guess i'm just trying to see if you're writing 100s of auto increments per second.
<2> There is no "chance". It does what it states.
<14> dogwater: it will never be wrong, when and how you get it could make it wrong for you.. but last_insert_id is always true
<2> Read how it works.
<14> dogwater: i do about 90 million autoincrements in a day. i've found last_insert_id very trustworthy
<14> i believe i do more than a 100 inserts/sec
<2> When you understand how it works, I can't see how you can not "trust" it.
<19> I could see a concurrency issue there. if you have another connection also doing inserts, you select a last_insert_id(), increment it, and try and use that as your next ID, but another connection has already used that ID.. but that's about the only circumstances where it could fail.
<2> nope
<14> no, it's for that connection
<2> !m infi last insert id
<3> infi: (How to Get the Unique ID for the Last Inserted Row) : http://dev.mysql.com/doc/mysql/en/Getting_unique_ID.html
<20> Is NOW() - datetime value = seconds?
<19> yes, I know it is within a connection, but if the other connection didn't use the same code (perhaps an INSERT with no id value, defaulting to the next free one).
<2> no
<15> uhhh
<19> ok, I'll go read :)
<15> that's what auto_increment does
<21> is there a way to have field values determined based on a formula? in excel for instance, I can say a particular cell = "A2 + B3"... is there a way to do that in mysql?
<15> !rtfm SELECT
<3> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<18> select col1+col2?
<21> no, i dont want it controlled at the select level
<15> !rtfm insert
<3> (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<15> !rtfm update
<3> (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<21> see
<21> i dont want to control it at the code level
<18> stored procedures / triggers?
<21> k
<21> now we're getting somewhere
<21> what are triggers? :P
<21> well
<21> ill go read up
<18> rtfm
<21> :P
<2> sjrussel, I think you're the only one who uses rtfm... heh
<21> !rtfm stored procedures
<3> (Stored Procedures and Functions) : http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html
<21> !rtfm triggers
<3> (Triggers) : http://dev.mysql.com/doc/mysql/en/Triggers.html
<2> Seriouslly, you can just go to dev.mysql.com and search yourself...
<2> And with that...... !fooP
<21> but aside from triggers and stored procedures.. theres no way to actually put a formula in a cell, that dictates its values, right?
<14> you could use excel
Return to
#mysql
or
Go to some related
logs:
Adept libstdc++5 ubuntu
module via not found
XFCe4 moz_no_remote
#perl
#bash
how to restart vsftpd
#suse
#osdev
ACCESS_DENIED access_wr
ANSI_ESCAPE_SEQUENCES
|
|