Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Paul,

A good lesson to learn ;-). 
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.

Best regards

Nils Valentin
Tokyo/Japan

2003年 7月 9日 水曜日 11:14、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

-- 
---
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils