Issue Access denied for user 'admin'@'localhost' after dist-upgrade

[Edi Duluman]

Server operating system version

Debian 11

Plesk version and microupdate number

Plesk Obsidian 18.0.65 Update #1

Hi. I have a very urgent issue. Everything went smoothly with the dist-upgrade from Debian 10 to Debian 11. Everything is now up and running, however, I can't get access to the mysql server for some reason.

I found a resolution in Plesk KB's asking me to add skip-grant-tables to [mysqld] in /etc/mysql/my.cnf which does indeed "fix" the issue by letting me at least get access to the plesk admin panel. However, a side-effect being that all databases for my sites show as "empty" ... see attached picture.



Running the folllowing command returns an error as well:

MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" mysql --silent --skip-column-names -h localhost -P 3306 -u admin -e 'SELECT VERSION()'

ERROR 1698 (28000): Access denied for user 'admin'@'localhost'

I've also ran the following commands after adding skip-name-resolve to [mysqld] in /etc/mysql/my.cnf

root@agency ~ # MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin -h ::1
ERROR 1130 (HY000): Host '::1' is not allowed to connect to this MariaDB server

root@agency ~ # MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin -h 127.0.0.1
ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MariaDB server

root@agency ~ # MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin -h localhost
ERROR 1698 (28000): Access denied for user 'admin'@'localhost'

However, if I add skip-grant-tables the above commands obviously work, but none of the sites can connect to their specific databases as they are "not found" anymore.

Please advise ... I'm not sure what to do.