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 · 272 阅读 · 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 · 281 阅读 · 0 评论
分享