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; 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. I have absolutely no idea what this means. I'm issuing this under w2k3 on mysql 5. Would anyone happen to know of a way to troubleshoot this? Thanks
