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 > >Ç„ÇÒÇÕèëÇ´ÇÐǵ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: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
