查看“Mysql8”的源代码




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=
[https://blog.csdn.net/qq_21870555/article/details/80711187 JDBC连接MySQL报错Unknown system variable 'query_cache_size']



[https://blog.csdn.net/vkingnew/article/details/80105323 MySQL 8.0报错：error 2059: Authentication plugin 'caching_sha2_password' cannot be loaded]


[https://blog.csdn.net/Hello_World_QWP/article/details/80353113 ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded; 的解决办法]

[https://www.cnblogs.com/dobbin2018/p/9645872.html mysql80远程登录问题--caching_sha2_password]

=see also=


[https://blog.csdn.net/yunyexiangfeng/article/details/82876964 mysql8使用grant授权修改]

[https://blog.csdn.net/skyejy/article/details/80645981 mysql8.0创建用户授予权限报错解决方法]

[[category:mysql]]