Ahhh. I didn't pay any attention to the quotes. Thanks
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 6:22 PM To: Marvin Cummings; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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 [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]
