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 [EMAIL PROTECTED] 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.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
