0

I installed the mysql-server-5.1 package on Debian 6. Changed the bind-address to 10.100.1.10 (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/mysqld.pid 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]:
5
  • After the initial start, if you tried to start up manually mySQL, will it start up then?
    – Rilindo
    Jul 25, 2011 at 2:02
  • Where's the log entries that describe what actually happened to mysqld?
    – womble
    Jul 25, 2011 at 6:09
  • @Rilindo Yes, it starts up without a problem.
    – Aco
    Jul 25, 2011 at 18:20
  • @womble They are included in my original post. Can't you see the log?
    – Aco
    Jul 25, 2011 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, 2011 at 22:23

1 Answer 1

0

/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.

2
  • So I just have bind-address 10.100.1.10 and bind-address 127.0.0.1 to my my.cnf file?
    – Aco
    Jul 25, 2011 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, 2011 at 16:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .