Re: Trouble creating users

2003-07-08 Thread Paul DuBois
At 8:55 -0700 7/8/03, Michael Iatauro wrote: I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-) To my knowledge, the semicolon is unnecessary when using mysql --ex

Re: Trouble creating users

2003-07-08 Thread Nils Valentin
2003年 7月 9日 水曜日 00:55、Michael Iatauro さんは書きました: > > I took once moe a sharp look now that you did a reply with another > > sample. Actually I was wrong the SQL statement was NOT correct - you > > forgot the semicolon in the first exapmple ;-) > > To my knowledge, the semicolon is unnecessary when u

Re: Trouble creating users

2003-07-08 Thread Michael Iatauro
I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-) To my knowledge, the semicolon is unnecessary when using mysql --execute. ~Michael Iatauro -- MySQL General Ma

Re: Trouble creating users

2003-07-07 Thread Nils Valentin
Hi Michael; I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-) 'Y', 'Y', 'Y');\"" Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 09:38、Michael I

Re: Trouble creating users

2003-07-07 Thread Michael Iatauro
Thanks for your reply, Nils. and then I would like you to take a sharp look at whats left, then there should perhaps be something with this part above. Perhaps the " at the very end is not escaped correctly (double) or something similar. The actual SQL statement works perfectly fine. I thought

Re: Trouble creating users

2003-07-07 Thread Nils Valentin
thing with this part above. Perhaps the " at the very end is not escaped correctly (double) or something similar. The actual SQL statement works perfectly fine. Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 08:28、Michael Iatauro さんは書きました: > I've been having a little trouble

Trouble creating users

2003-07-07 Thread Michael Iatauro
I've been having a little trouble creating users cross-platform. I have a little script that works just fine on Solaris 8 using this command: eval "/path/to/mysql --user=root --password=* --socket=/path/to/socket --database=mysql --execute=\"INSERT INTO user (Host,