Home > Cisco, Debian, Linux, mysql > Mysqld doesnt start on Debian

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

Categories: Cisco, Debian, Linux, mysql Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.