mysql8.0错误：this authentication plugin is not supported
mysql错误：this authentication plugin is not supported
展开
this authentication plugin is not supported
应用程序连接mysql docker一直报错：this authentication plugin is not supported。
google发现，原来是mysql新版本（8.0以上）将root用户使用的plugin更新成caching_sha2_password。
登录mysql输入如下命令可以看到：
mysql> select user,plugin from mysql.user;
+------------------+-----------------------+
| user | plugin |
+------------------+-----------------------+
| root | caching_sha2_password |
| mysql.infoschema | mysql_native_password |
| mysql.session | mysql_native_password |
| mysql.sys | mysql_native_password |
| root | caching_sha2_password |
+------------------+-----------------------+
解决办法有：
（1）降级，使用老版本mysql。
（2）将root的plugin改成mysql_native_password。
这里改成：
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;
这行代码有两层含义，第一:修改root的密码为’root’，摒弃原来的旧密码。第二：使用mysql_native_password对新密码进行编码。
然后再启动应用，还是一样报错。再看mysql.user,发现还有一个host”%”的root用户：
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | root | caching_sha2_password |
| localhost | mysql.infoschema | mysql_native_password |
| localhost | mysql.session | mysql_native_password |
| localhost | mysql.sys | mysql_native_password |
| localhost | root | mysql_native_password |
+-----------+------------------+-----------------------+
5 rows in set (0.00 sec)
将这个用户也改了：
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
再看：
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | root | mysql_native_password |
| localhost | mysql.infoschema | mysql_native_password |
| localhost | mysql.session | mysql_native_password |
| localhost | mysql.sys | mysql_native_password |
| localhost | root | mysql_native_password |
+-----------+------------------+-----------------------+
改成功了，再启动应用，报错：
this user requires mysql native password authentication
在连接mysql的url上加上?allowNativePasswords=true，这次正常了。
原文链接：https://blog.csdn.net/c359719435/article/details/80432508
----------------------------------------------------------------------------------------------------------------------------
go连接MySQL报错：this authentication plugin is not supported的解决
原创Elonjelinek 发布于2018-09-09 10:58:25 阅读数 4166 收藏
展开
MySQL升级8.0以上版本后，在用第三方库github.com/Go-SQL-Driver/MySQL打开数据库时会报错this authentication plugin is not supported，这是因为MySQL8.0版本修改了加密方式，所以只要修改一下密码的加密方式就可以了。
首先用root用户进入MySQL，修改root用户的密码和加密方式：这里修改密码为abc345
mysql> alter user root@localhost identified with mysql_native_password by 'abc345';
Query OK, 0 rows affected (0.13 sec)
mysql>
查询当前所有用户：
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| 127.0.0.1 | Tom | caching_sha2_password |
| localhost | Tom | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | mysql_native_password |
+-----------+------------------+-----------------------+
6 rows in set (0.00 sec)
这里总共查询出来6个用户，刚才修改的是第6个，也就是最后一个用户| localhost | root | mysql_native_password |的密码和加密方式。可以看到，该用户的加密方式mysql_native_password已经不同于上面的其他5个加密方式了。
再修改其他用户：
mysql> alter user Tom@127.0.0.1 identified with mysql_native_password by '456789';
Query OK, 0 rows affected (0.03 sec)
查看：
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| 127.0.0.1 | Tom | mysql_native_password |
| localhost | Tom | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | mysql_native_password |
+-----------+------------------+-----------------------+
6 rows in set (0.00 sec)
mysql>
之后重启MySQL，再次连接就可以了。
原文链接：https://blog.csdn.net/charliewolf/article/details/82556583