Error: User add failed. Error: Plugin caching_sha2_password could not be loaded
Error: User add failed. Failed to connect to database: Error: Plugin caching_sha2_password could not be loaded: Dynamic loading not supported. . An error occurred. Please contact administrator.. ]0;
Error in Ezeelogin software GUI:
Error in Ezeelogin Shell (ezsh)
How to fix Error: Plugin caching_sha2_password could not be loaded: Dynamic loading not supported in MySQL version 8.0?
1. Login to the MySQL server and check the plugin used by the Ezeelogin user. Ezeelogin user should use the mysql_native_password plugin to fix the above error. Refer below example.
root@gateway:~# mysql -u root -p
Enter password:
mysql> use mysql;
mysql> select user,plugin from mysql.user;
+------------------+-----------------------+
| user |plugin |
+------------------+-----------------------+
| ezlogin_qamqje | caching_sha2_password |
| root | mysql_native_password |
+------------------+-----------------------+
2. Login to the gateway server and retrieve the MySQL username and password. Refer below example.
root@gateway:~# php /usr/local/ezlogin/eztool.php -show_db_credentials
Username: ezlogin_qamqje
Password: MA/f7ZSZsq2G[C}JSPZ$A)/yj8A
3. Login to MySQL server as root user and update the user plugin with mysql_native_password.
root@gateway:~# mysql -u root -p
Enter password:
mysql> alter user 'ezlogin_qamqje'@'localhost' identified with mysql_native_password by 'MA/f7ZSZsq2G[C}JSPZ$A)/yj8A';
mysql> flush privileges;
4. Confirm that plugin has changed to mysql_native_password for the Ezeelogin user.
root@gateway:~# mysql -u root -p
Enter password:
mysql> use mysql;
mysql> select user,plugin from mysql.user;
+------------------+-----------------------+
| user |plugin |
+------------------+-----------------------+
| ezlogin_qamqje | mysql_native_password |
| root | mysql_native_password |
+------------------+-----------------------+
5. Login to Ezeelogin GUI and backend (ezsh) to confirm everything works fine.
Related Article