MySQL in Linux might have some problems with the authentication.
If this error is shown, please command below options:
SQL Error Opening: Authentication plugin 'caching_sha2_password' cannot be loaded: /user/lib64/mysql/plugin/chaching_sha_password.so: Cannot open shared object file: No such file or directory QMYSQL: Unable to connect.
Open the terminal and command below;
mysql -u root -p
[enter password if set]
ALTER USER ‘[user]’@’[IP]’ IDENTIFIED WITH mysql_native_password BY ‘[password]’; FLUSH PRIVILEGES;
[user] = the user of the database
[IP] = the IP range of where you can reach the database from, use % for all IP's
[password] = the IP of the user for the database
ALTER USER ‘wipedrive’@’%’ IDENTIFIED WITH mysql_native_password BY ‘Test12345!’; FLUSH PRIVILEGES;
Snip of error:
If this article was not helpful and more help is needed please contact us via one of below options.
Our official support hours are 8:00 am to 16:30 pm, after those hours emailing us or submitting a ticket would be the best option.
When contacting our support team, please refer to the article you’ve checked and if possible add a picture of the error and add information on the hardware that’s giving the error. Make always sure you’re using the latest version.