在CentOS 6.5中,安装mysql 5.6版本后,启动Mysql服务,使用命令:
mysql -u root -p pouyye
连接时报错:
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
解决方法:
1.停止mysqld服务
2.使用如下命令启动服务:
mysqld_safe --user=mysql --skip-grant-tables
注:
–skip-grant-tables:表示跳过授权控制
3.启动后效果如下:
150922 11:33:57 mysqld_safe Logging to '/var/log/mysqld.log'.
150922 11:33:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
4.另开一shell窗口,使用命令:
mysql
连接到mysql数据库,然后分别执行如下操作:
mysql> select host,user from user where user ='root';
+-------------+------+
| host | user |
+-------------+------+
| % | root |
| 127.0.0.1 | root |
| VM000001964 | root |
+-------------+------+
3 rows in set (0.00 sec)
mysql> update user set password=password('Chinawiservqz#') where user='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
5.重启mysqld服务:
service mysqld restart
6.最后执行命令,升级mysql数据库结构。
mysql_upgrade -uroot -p