► ๖ۣۜLINH ๖ۣۜOLIVER ◄

error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2)

mysqld --tc-heuristic-recover=ROLLBACK

Didn’t quite do the magic for me. However the following worked

mysqld_safe --tc-heuristic-recover=COMMIT

I was able to overcome this issue on CentOS 6 with

service mysql start --tc-heuristic-recover=ROLLBACK

which ultimately discarded the commit in question. I’m not sure if systemd scripts support passing additional parameters. Maybe you could try and run it manually with the =

mysqld --tc-heuristic-recover=ROLLBACK

or

sudo service mysql start --tc-heuristic-recover=0