Question MariaDB and default socket with ubuntu 18.04

[dmathis]

I got Plesk installed a while ago with mariadb, now unfortuantely mysql_upgrade fails because it cannot find the socket. Actually Plesk did auto-update, and I suppose mariadb got also updated, which triggered the mysql_upgrde, which failed (which lead to an error 500, same as this one).

By default the socket is here: /var/lib/mysql/mysql.sock
But the mysql client looks for it in:/var/run/mysqld/mysqld.sock

So I run

ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock

and rerurn mysql_upgrade with

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --force

and that fixed it, Plesk worked again.


The question is now, what is the best practice here?
- Should I alter my.cnf to create the socket at the proper place?
- Did I wrongly installing MariaDB for Plesk?
- Or should I reinstall Plesk using MySQL instead of MariaDB?