Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed the mysql-server-5.1 package on Debian 6. Changed the bind-address to (for internal use), and when I reboot the server it doesn't start up mysql. This is what the syslog says:

Jul 24 18:04:39 server0 mysqld:
Jul 24 18:04:39 server0 mysqld_safe: mysqld from pid file /var/run/mysqld/ ended
Jul 24 18:04:46 server0 kernel: [   13.786387] eth0: no IPv6 routers present
Jul 24 18:04:48 server0 /etc/init.d/mysql[1419]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 24 18:04:48 server0 /etc/init.d/mysql[1419]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 24 18:04:48 server0 /etc/init.d/mysql[1419]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 24 18:04:48 server0 /etc/init.d/mysql[1419]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 24 18:04:48 server0 /etc/init.d/mysql[1419]:
share|improve this question
After the initial start, if you tried to start up manually mySQL, will it start up then? – Rilindo Jul 25 '11 at 2:02
Where's the log entries that describe what actually happened to mysqld? – womble Jul 25 '11 at 6:09
@Rilindo Yes, it starts up without a problem. – Aco Jul 25 '11 at 18:20
@womble They are included in my original post. Can't you see the log? – Aco Jul 25 '11 at 18:20
I see an empty entry from mysqld, one from mysqld_safe, and a bunch from the init script. No actual entries from mysqld (and I wouldn't expect them to end up in syslog by default, anyway). – womble Jul 25 '11 at 22:23

/usr/bin/mysqladmin: connect to server at 'localhost' failed

Looks like you didn't include localhost in the list when you changed bind-address, but you also didn't change /etc/init.d/mysql to try connecting to an address that is bound. You'll need to do one or the other - the first is probably a better choice.

share|improve this answer
So I just have bind-address and bind-address to my my.cnf file? – Aco Jul 25 '11 at 18:16
That shouldn't be the case, I have plenty of servers bound to eth devices that are still accessible from lo... – Kura Jul 27 '11 at 16:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.