[root@zabbix mysql5]# mysql -pxinnetdb2013 -h11.10.115.68
ERROR 1045 (28000): Access denied for user 'root'@'119.10.115.68' (using password: YES)
[root@zabbix mysql5]# mysql -pxinnetdb2013 -h127.0.0.1
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: YES)
[root@zabbix mysql5]#
[root@zabbix mysql5]# mysql -pxinnetdb2013 -h localhost
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@zabbix mysql5]# mysql -pxinnetdb2013 -h 127.0.0.1
解决方法如下:
kill -9 杀掉mysql
mysqld_safe & --skip-grant-tables
mysql -p
mysql> update mysql.user set password=password('111') where user='root';
mysql>flush privileges ;
mysql> exit
再次登陆就可以了 这个方法我还是第一次使用
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-764790/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-764790/