Hello everybody,

It’s been a while and today I was stuck on an older machine trying to upgrade a broken mysql update.

I had this error during the sudo apt upgrade command:

mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server

After trying different solutions posted on StackOverflow, I was able to fix it with this combination of commands:

sudo systemctl enable mysql
sudo service mysql start
sudo apt dist-upgrade

This bug is reproducible by running sudo systemctl disable mysql before a MySQL upgrade.

Good luck!

source