Oct 17, 2019
60 Views
Comments Off on Can’t start mysqld/mysql

Can’t start mysqld/mysql

Written by

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

Article Categories:
Code/Web
    http://linholiver.com

    https://linholiver.com/diary/about/