this authentication plugin is not supported

應(yīng)用程序連接mysql docker一直報錯：this authentication plugin is not supported。
google發(fā)現(xiàn)，原來是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對新密碼進(jìn)行編碼。

然后再啟動應(yīng)用，還是一樣報錯。再看mysql.user,發(fā)現(xiàn)還有一個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 |
+-----------+------------------+-----------------------+

改成功了，再啟動應(yīng)用，報錯：
this user requires mysql native password authentication
在連接mysql的url上加上?allowNativePasswords=true，這次正常了。
---------------------

轉(zhuǎn)載于:https://www.cnblogs.com/mafeng/p/10122582.html

總結(jié)

以上是生活随笔為你收集整理的mysql错误：this authentication plugin is not supported的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。