Ahhh. I didn't pay any attention to the quotes.
Thanks
-----Original Message-----
From: Paul DuBois [mailto:pa...@mysql.com]
Sent: Sunday, March 21, 2004 6:22 PM
To: Marvin Cummings; mys...@lists.mysql.com
Cc: wdvl...@lists.wdvl.com; li...@webdesign-l.com
Subject: Re: Bad syntax when trying to create mysql username and password...
At 18:11 -0500 3/21/04, Marvin Cummings wrote:
Can someone take a look and let me know what's wrong with this command:
GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@<dbhost> IDENTIFIED BY
'<dbpass>' WITH GRANT OPTION;
So for me I say:
GRANT ALL PRIVILEGES ON testdb.* TO root@localhost IDENTIFIED BY mypassword
WITH GRANT OPTION;
You're not quoting the password. It's a string. That's why the error
message says the beginning of the problematic part of the statement
is at 'mypassword with grant option' at line 2.
It returns the following error:
Error 1064 <42000>: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'mypassword with grant option' at line 2.
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
3 messages in com.mysql.lists.mysqlRE: Bad syntax when trying to create ...