Mysqld doesnt start on Debian
Problem: Mysql server is not starting and it is giving the following error:
# /usr/sbin/mysqld –verbose
080729 12:57:28 [ERROR] Can’t start server: cannot resolve hostname!: Success
More error logs:
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Solution: In the /etc/mysql/my.cnf file default was changed as below & mysql started normally.:) Customize the settings according to your need. This makes mysql only open to localhost services.You may put 0.0.0.0 to listen on all interfaces.
bind-address = 127.0.0.1