mysql安装后权限问题

mysql> use mysql
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
mysql> exit
Bye
[root@testtest ~]# service mysqld stop
Stopping mysqld: [ OK ]
[root@testtest ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

[root@testtest ~]# mysql -u root -p -hlocalhost
Enter password:

mysql> use mysql

mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;

mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

mysql> FLUSH PRIVILEGES;

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' identified by '' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'cn.cn.cn.cn'identified by '';

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'245.245.245.245'identified by '';

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'127.0.0.1' identified by '';

mysql> FLUSH PRIVILEGES;

mysql> quit
Bye
[root@testtest ~]# service mysqld start