When adding database connections you may run into the error Unable to connect to the MySQL server.
This could happen when the default authentication plugin is set to caching_sha2_password for the root user being instead of mysql_native_password. This authentication plugin is the new default in MySQL 8, and documentation is available regarding compatibility issues with the use of caching_sha2_password: https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatibility-issues
mysql> select user, host, plugin from mysql.user;
+------------------+-----------+-----------------------+
| user | host | plugin |
+------------------+-----------+-----------------------+
| root | % | caching_sha2_password |
| cost | localhost | mysql_native_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)
To resolve this issue, you could update your root user to use mysql_native_password for authentication with the help of your qualified server administrator. There are some community resources available online for this here:
https://www.digitalocean.com/community/questions/how-to-change-caching_sha2_password-to-mysql_native_password-on-a-digitalocean-s-managed-mysql-database
https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
If you would prefer to keep using the caching_sha2_password authentication plugin for your root user, you could add a new MySQL user using the mysql_native_password plugin for use with JetBackup.
Please note that the new user would require all privileges for all databases per the requirements at https://docs.jetbackup.com/linux/manual/DatabaseConnections/DatabaseTypes/mySQL.html
