Here's my dilemma. I forgot the user/pass to my database (this is on a Virtual Server if that matters) so the first thing I did was shut down mysql. Then I restarted it with the --skip-grant-tables option. Now I issue the following command:
grant all privileges on mydb.* to myuser@localhost identified by 'mypassword';
However I get a "Error 1047: Unknown Command" every time. What am I doing wrong I swear I have done this a thousand times.
