Resolved After upgrading from ubuntu 18.04 to Ubuntu 20.04 MySQL 8.0 and plesk stop working at 100%

[EmilioO]

Server operating system version

Ubuntu 20.04

Plesk version and microupdate number

18.0.64 #1

I used the script to upgrade ubuntu 18.04 to 20.04, upgrade fails and I have to manually recovery packages and database dumps from backup.
After many fixes I got plesk running again but certain tasks (backups, plesk repair installation) fails which the error "Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory"

I'm using ubuntu 20.4 and Plesk obsidian 18.0.64 Update 1

I've checked another server with Ubuntu 20.04, Plesk and MariaDB 10 and this file "/usr/lib/mariadb/plugin/caching_sha2_password.s" doesn't exists.

 

[Sebahat.hadzhi]

The issue is most likely caused because the 'caching_sha2_password' authentication plugin used for the 'apsc' database user. What you can do is try to configure the user to use 'mysql_native_password' authentication instead.

1. Back up Plesk databases:
   

   plesk db dump > psadump.sql

2. Log in to the 'mysql' database:
   

   plesk db
   ...
   mysql> use mysql;

3. Change authentication plugin:
   

   mysql> ALTER USER 'apsc'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY '<password>';
   Query OK, 0 rows affected (0.03 sec)
   
   mysql> quit

4. Update credentials stored in the 'psa' database using 'plesk repair db' utility:
   

   plesk repair db

 

[EmilioO]

Thanks, finally resolved the problem by switching to MariaDB.

 

[TELLO0815]

Thanks, finally resolved the problem by switching to MariaDB.

Hi EmilioO,
I facing the same issue ...
Can you explain me the way you switched from MySQL to MariaDB?
I tried some older ways from Plesk website, but all not successful.

 

[EmilioO]

https://support.plesk.com/hc/en-us/...ch-from-MySQL-to-MariaDB-on-Plesk-for-Windows

MySQL vs MariaDB – Can One Replace The Other?

With all MariaDB's power under the hood, “MySQL vs MariaDB” was suddenly a legitimate topic of conversation. The two databases are so similar that MariaDB negates the need to upgrade mysql, because it can usually replace MySQL in a straight swap. Here's an in-depth comparison of the two, their...

www.plesk.com

But be careful the guide its not 100% correct. I think you don't hace to import Mysql main database.

 

[TELLO0815]

Ah... you not using Linux. Looks like with Windows you can add by components and with linux its not possible. Must be installed with shell.

 

[EmilioO]

I'm using Ubuntu, check the second link, also in first link point to Plesk article for linux.