mysql更改root密码

问题描述

在尝试登陆 mysql 时,无法登陆,提示:

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

若不加-p参数,using password: NO

而其他账户可以登陆

故更改 root 密码

解决方案

1. 更新 mysql 密码

➜  ~ mysqladmin -u root password  1234
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

失败

2. 进入安全模式

systemctl stop mariadb
mysqld_safe --skip-grant-tables    ### 持续运行
mysql -u root

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';   ### password 即为设置的密码

systemctl start mariadb

密码更改成功

参考链接

• https://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y