The Ultimate Guide to High Availability with MariaDB

Comments - got "ERROR 2003 (HY000): Authentication with backend failed. Session will be closed." with MySQL 8.0

4 years, 7 months ago Markus Mäkelä
Re: got "ERROR 2003 (HY000): Authentication with backend failed. Session will be closed." with MySQL 8.0 [Answer]

You have to configure the backends with default_authentication_plugin=mysql_native_password, MySQL 8.0 uses the caching_sha2_password plugin by default.

 
4 years, 7 months ago 學豪 方
Re: got "ERROR 2003 (HY000): Authentication with backend failed. Session will be closed." with MySQL 8.0

Markus, Thank you very much! Yes, it works. But, I do not understand that all users had been created with "IDENTIFIED WITH mysql_native_password" why should add it in my.cnf? 

mysql> SELECT User, Host, Plugin  from mysql.user  WHERE User LIKE 'Max%';
+------------+------------+-----------------------+
| User       | Host       | Plugin                |
+------------+------------+-----------------------+
| MaxMonitor | 168.6.42.% | mysql_native_password |
| MaxService | 168.6.42.% | mysql_native_password |
+------------+------------+-----------------------+
2 rows in set (0.00 sec)

mysql>
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.