Access denied for user ‘root’@‘localhost’

最新推荐文章于 2024-07-31 10:29:06 发布

Cleansely

最新推荐文章于 2024-07-31 10:29:06 发布

阅读量161

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/Cleansely/article/details/111577108

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

文章目录

- Access denied for user 'root'@'localhost'

Access denied for user ‘root’@‘localhost’

环境:centos7, rpm安装的mysql

解决:

service mysqld stop  #关闭mysql

vi my.cnf  #跳过密码
skip-grant-table

service mysqld start  #开启mysql
mysql  #修改密码
flush privileges;
alter user 'root'@'localhost'IDENTIFIED BY 'MyNewPass@123';
flush privileges;

# 可选:简单密码
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;

# 重启mysql
service mysqld stop  #关闭mysql

vi my.cnf  #跳过密码
#skip-grant-table

service mysqld start  #开启mysql