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.