List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 21 2002 8:38pm
Subject:Re: Access denied on use mysql;
View as plain text  
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
>
>


Thread
Access denied on use mysql;alan410018 Mar
  • Re: Access denied on use mysql;Joel Rees19 Mar
  • Re: Access denied on use mysql;Liyju Janardhan19 Mar
  • Re: Access denied on use mysql;Joel Rees20 Mar
  • Re: Access denied on use mysql;alan410020 Mar
    • Re: Access denied on use mysql;Doug Thompson20 Mar
  • Re: Access denied on use mysql;Kathy Reyes20 Mar
  • Re: Access denied on use mysql;alan410020 Mar
  • Re: Access denied on use mysql;alan410020 Mar
Re: Access denied on use mysql;alan410020 Mar
Re: Access denied on use mysql;alan410020 Mar
Re: Access denied on use mysql;Kathy Reyes20 Mar
Re: Access denied on use mysql;alan410021 Mar
Re: Access denied on use mysql;alan410021 Mar
  • Re: Access denied on use mysql;Kathy Reyes21 Mar
  • Re: Access denied on use mysql;Kathy Reyes21 Mar
    • Re: Access denied on use mysql;Liyju Janardhan22 Mar
  • Re: Access denied on use mysql;Gerald Clark21 Mar
  • Re: Access denied on use mysql;alan410021 Mar
Re: Access denied on use mysql;alan410021 Mar
Re: Access denied on use mysql;alan410021 Mar
  • Re: Access denied on use mysql;Colin Faber21 Mar
Re: Access denied on use mysql;alan410022 Mar
  • Re: Access denied on use mysql;Brian Reichert22 Mar
Re: Access denied on use mysql;Victoria Reznichenko22 Mar
Re: Access denied on use mysql;alan410023 Mar