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
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
