MySQL Connection Failed! 1045: Access denied for user

来源:互联网 发布:mac连不到app store 编辑:程序博客网 时间:2024/05/21 12:18

[2012-05-04,10:15:11:414] MySQL Connection Failed! 1045: Access denied for user'root'@'192.168.8.27' (using password: YES)

解决方法:

mysql> grant all privileges on *.* to root @’%’ identified by 'password' with grant option;
mysql> update user set password=PASSWORD('password') where user='root';
mysql> flush privileges;


 

原创粉丝点击