(1698, “Access denied for user ‘root‘@‘localhost‘“)

一时失言乱红尘 2023-02-26 02:11 14阅读 0赞

# **(1698, "Access denied for user 'root'@'localhost'")** #

**Mysql 报错问题处理：**

Django 启动的时候报错：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 1][]

sudo mysql -u root

进入到mysql 命令行

sue mysql
    SELECT User, Host, plugin FROM mysql.user;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 2][]

可以看到，root用户使用auth\_socket 插件

可以将root用户设置为使用mysql\_native\_password插件

UPDATE user SET plugin='mysql_native_password' WHERE User='root';

![20200713174436405.png][]

FLUSH PRIVILEGES;

![20200713174454687.png][]

退出，重启mysql

service mysql restart

再次登录。查询，已经修改成功。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/202007131740517.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 1]: /images/20230209/d728c548c8e44e409b6f2fc60cd2d5bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200713174140816.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM=,size_16,color_FFFFFF,t_70
[20200713174436405.png]: https://img-blog.csdnimg.cn/20200713174436405.png
[20200713174454687.png]: https://img-blog.csdnimg.cn/20200713174454687.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200713174531994.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI3OTg2ODM=,size_16,color_FFFFFF,t_70