Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Paul DuBois]

At 10:35 +0900 7/7/03, Nils Valentin wrote:
>2003îN 7åé 7ì™ åéójì™
> 10:28ÅANils Valentin
> DŽÇÒÇÕèëÇ´ÇÐǵLJ:
>>  Hi Kevin,
>>
>>  try this:
>>
>>  1) stop the mysql server
>>  2) mysqld_safe --skip-grant-tables
>>  3) mysql -u root
>>  4) mysql> SHOW GRANTS FOR root;
>>  5) GRANT ALL ON *.* TO 'root'@'%';
>
>  GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
>
>
>sorry for the mistake.

Actually, the mistake is a different one:

When you start the server with --skip-grant-tables, it doesn't read
the grant tables *at all*.  That means the GRANT and REVOKE statements
are disabled.  (That's the reason for the "unknown command" error
reported in other messages in this thread.)

However, once you connect to the server, you can issue FLUSH PRIVILEGES
to force the server to r-eread the grant tables into memory.  That also
has the effect of re-enabling GRANT and REVOKE.  (This is why Victoria
said that FLUSH PRIVILEGES should be used before the GRANT statement.)

>
>Best regards
>
>Nils Valentin
>Tokyo/Japan


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/