MySQL Access denied for user 'root'@'localhost' 解决方法

发表于 2018-04-10 | 分类于 MySQL | 阅读次数

执行 mysql -uroot -ppassword 出现如下错误

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

停止mysql

1
2
3

# service mysql stop
//or
# /usr/local/mysql/support-files/mysql.server stop

安全模式启动

1
2
3

//找到mysqld_safe所在位置
# find /usr/local/mysql -name "mysqld_safe"
# mysqld_safe --skip-grant-tables --skip-networking &

安全模式进入mysql

1
2
3

# mysql -u root
//password替换为你要修改的密码
mysql> UPDATE mysql.user SET PASSWORD=PASSWORD('password') WHERE USER='root';

启动mysql，问题解决

1
2
3

# service mysql start
//or
# /usr/local/mysql/support-files/mysql.server start