![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
tanhuanzheng
这个作者很懒,什么都没留下…
展开
-
“Host ‘xxxx‘ is not allowed to connect to this MySQL server“
use mysql;update user set host='%' where user='root';flush privileges;原创 2020-10-21 17:21:07 · 140 阅读 · 0 评论 -
mysql修改root用户的密码
格式:mysqladmin -u用户名 -p旧密码 password 新密码例子:mysqladmin -uroot -p123456 password 123原创 2020-10-21 17:18:46 · 122 阅读 · 0 评论 -
pymysql.err.OperationalError: (1698, “Access denied for user ‘root‘@‘localhost‘“)
pymysql.err.OperationalError: (1698, “Access denied for user ‘root’@‘localhost’”)$ sudo mysql -u root mysql> USE mysql;mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';mysql> FLUSH PRIVILEGES;mysql> exit;$ service原创 2020-10-08 10:37:46 · 5660 阅读 · 9 评论