Grant all on mysql.* to 'root'@'localhost' identified by "password";
What version MySQL are you running?
You need 3.23 for GRANT to work.
Kathy Reyes wrote:
>I just gave up, everything that I tried did not work.
>
>I killed mysql and then
>started with safe_mysql --skip-grant-tables
>then I was able to connect to mysql without an error.
>But when I tried to
>Grant all on mysql.* to root@localhost identified by "password";
>it gave me the message Unknown Command.
>
>----- Original Message -----
>From: "alan4100" <alan4100@stripped>
>To: <mysql@stripped>
>Sent: Thursday, March 21, 2002 11:07 AM
>Subject: Re: Access denied on use mysql;
>
>
>>mysql
>>
>>Hello Kathy,
>>
>>How have you made out with access to mysql?
>>
>>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread103788@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
