RE: mysql root password problem

[Robert Goff]

> mysql> grant all on *.* to root@localhost identified by "my_password"
> with grant option;
> ERROR 1047: Unknown command

You have to FLUSH PRIVILEGES *before* the GRANT command.  (Subject of a
recent thread on this list.)

--
I took an IQ test, and the results were negative.
===============================================
Robert Goff      beast@stripped
Technical Writer/Editor, Webmaster 505-564-8959