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
Hi Michael, I am not a script person, but let me try to help you figuring out whats wrong. First I assumed that the user executing the script has the necessary privileges t update the privilege database /datadir/mysql (for Linux f.e /var/lib/mysql/mysql) . The second I tried your SQL statemen