-2

Running 14.0.2 LTS version

Server restarted and I was not able to access MYSQL 

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

Tried all possible solution provided but nothing seems to be working 

root@controller:~# ps -ef | grep mysql
root      7591  6127  0 18:40 pts/4    00:00:00 grep mysql

root@controller:~# kill -9 6127
Killed

root@controller:~# /etc/init.d/mysql start
 * Starting MySQL database server mysqld
   ...fail!

I have multiple tables in the server and reinstalling it is not an option :(

I am running this server as a controller in ICEHOUSE openstack installation.

Please help

2707974
  • 10,758
Arunjunai Bhaskaran
  • 1
  • 1

1 Answers1

2

The MySQL server cannot start for some reason. This reason should be detailed in the MySQL error log, try tailing /var/log/mysql.err for further information.

I've had this happen when some sort of post upgrade action is required. Without seeing the corresponding log entries, however, this would be hard to diagnose.

kelvinelove
  • 1,619
Asphy
  • 21