“Mysql8”的版本间的差异
跳到导航
跳到搜索
小 （导入1个版本） |
（→R） |
||
| （未显示同一用户的4个中间版本） | |||
| 第3行： | 第3行： | ||
ERROR 1410 (42000): You are not allowed to create a user with GRANT | ERROR 1410 (42000): You are not allowed to create a user with GRANT | ||
| + | =mysql8 caching_sha2_password trouble = | ||
| + | == trouble Authentication plugin 'caching_sha2_password'== | ||
| + | <pre> | ||
| + | php artisan command:init-all-permission#初始化导致问题 | ||
| + | Authentication plugin 'caching_sha2_password' cannot be loaded | ||
| + | PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] | ||
| + | </pre> | ||
| + | |||
| + | ==shooting== | ||
| + | <pre> | ||
| + | 建用户 这个试过可以的 mysql8 新用户和授权 | ||
| + | |||
| + | create user 'live'@'%' identified by 'effsdf7'; | ||
| + | #把mysql8 默认安全比较高的 caching_sha2_password改为 mysql_native_password,其实不是一个好的做法 | ||
| + | # 最好是 upgrade mysql client | ||
| + | ALTER USER 'live'@'%' IDENTIFIED WITH mysql_native_password BY 'effsdf7'; | ||
| + | |||
| + | grant select,insert,update,delete on *.* to 'live'@'%'; | ||
| + | |||
| + | flush privileges;刷新权限 | ||
| + | |||
| + | 授权 good 比较细的权限分授权 | ||
| + | |||
| + | 如：grant select,insert,update,delete on *.* to 'liveapp'@'%'; | ||
| + | |||
| + | grant select,insert,update,delete on `live-`.* to 'lcphp'@'172.16.1.7'; | ||
| + | |||
| + | |||
| + | 原因 | ||
| + | |||
| + | MySQL8.0新特性——默认使用caching_sha2_password作为身份验证插件 | ||
| + | |||
| + | |||
| + | | % | cfbapp | caching_sha2_password | 新的比较安全的 | ||
| + | | % | liveapp | mysql_native_password 老的 改成这个为了php73 | ||
| + | |||
| + | </pre> | ||
| + | |||
| + | ==R== | ||
| + | [https://blog.51cto.com/fengfeng688/2147169 MySQL8.0新特性——默认使用caching_sha2_password作为身份验证插件] | ||
| + | |||
| + | [https://blog.csdn.net/qq_41538097/article/details/106905416 远程连接MySQL错误“plugin caching_sha2_password could not be loaded”的解决办法] | ||
| + | |||
| + | https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded | ||
| + | |||
| + | [https://blog.csdn.net/maoxinwen1/article/details/88629313 MySQL8.0登录提示caching_sha2_password问题解决方法] | ||
=trouble= | =trouble= | ||
2021年12月7日 (二) 08:39的最新版本
ERROR 1410 (42000): You are not allowed to create a user with GRANT
目录
mysql8 caching_sha2_password trouble
trouble Authentication plugin 'caching_sha2_password'
php artisan command:init-all-permission#初始化导致问题 Authentication plugin 'caching_sha2_password' cannot be loaded PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]
shooting
建用户 这个试过可以的 mysql8 新用户和授权 create user 'live'@'%' identified by 'effsdf7'; #把mysql8 默认安全比较高的 caching_sha2_password改为 mysql_native_password,其实不是一个好的做法 # 最好是 upgrade mysql client ALTER USER 'live'@'%' IDENTIFIED WITH mysql_native_password BY 'effsdf7'; grant select,insert,update,delete on *.* to 'live'@'%'; flush privileges;刷新权限 授权 good 比较细的权限分授权 如：grant select,insert,update,delete on *.* to 'liveapp'@'%'; grant select,insert,update,delete on `live-`.* to 'lcphp'@'172.16.1.7'; 原因 MySQL8.0新特性——默认使用caching_sha2_password作为身份验证插件 | % | cfbapp | caching_sha2_password | 新的比较安全的 | % | liveapp | mysql_native_password 老的 改成这个为了php73
R
MySQL8.0新特性——默认使用caching_sha2_password作为身份验证插件
远程连接MySQL错误“plugin caching_sha2_password could not be loaded”的解决办法
MySQL8.0登录提示caching_sha2_password问题解决方法
trouble
JDBC连接MySQL报错Unknown system variable 'query_cache_size'
MySQL 8.0报错：error 2059: Authentication plugin 'caching_sha2_password' cannot be loaded
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded; 的解决办法
mysql80远程登录问题--caching_sha2_password
