![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
Aaron2333
Buck up muggles!
展开
-
[Mysql 1130] Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
修改 /etc/mysql/mysql.conf.d/mysqld.cnf bind_address = 127.0.0.1 前加入#号 注释掉绑定地址 给需要连接的用户赋权限 >mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root_password' WITH GRANT OPTION; *.*被赋...原创 2019-04-24 02:28:30 · 217 阅读 · 0 评论 -
[Mysql 2059] Authentication plugin 'caching_sha2_password' cannot be loaded
You can change the encryption of the user’s password by altering the user with below Alter command : ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password'; OR We can ...原创 2019-04-24 02:44:55 · 208 阅读 · 0 评论