Facebook
TwitterI 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
and rerurn mysql_upgrade with
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?
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
Code:
ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock
Code:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --forceThe 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?
