Public bug reported: 1. Set the bind-address parameter in /etc/mysql/my.cnf to 192.168.0.4 2. Set your dhcp on your lan to give you the address 192.168.0.4 3. reboot the box where mysql is installed 4. mysql will not boot, complaining that: ---- Apr 8 15:36:46 black mysqld[6128]: 070408 15:36:46 [Note] /usr/sbin/mysqld: Normal shutdown Apr 8 15:36:46 black mysqld[6128]: Apr 8 15:36:46 black mysqld[6128]: 070408 15:36:46 InnoDB: Starting shutdown... Apr 8 15:36:48 black mysqld[6128]: 070408 15:36:48 InnoDB: Shutdown completed; log sequence number 0 43655 Apr 8 15:36:48 black mysqld[6128]: 070408 15:36:48 [Note] /usr/sbin/mysqld: Shutdown complete Apr 8 15:36:48 black mysqld[6128]: Apr 8 15:36:48 black mysqld_safe[6566]: ended Apr 8 16:38:37 black mysqld_safe[4749]: started Apr 8 16:38:38 black mysqld[4753]: 070408 16:38:38 InnoDB: Started; log sequence number 0 43655 Apr 8 16:38:38 black mysqld[4753]: 070408 16:38:38 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address Apr 8 16:38:38 black mysqld[4753]: 070408 16:38:38 [ERROR] Do you already have another mysqld server running on port: 3306 ? Apr 8 16:38:38 black mysqld[4753]: 070408 16:38:38 [ERROR] Aborting Apr 8 16:38:38 black mysqld[4753]: Apr 8 16:38:38 black mysqld[4753]: 070408 16:38:38 InnoDB: Starting shutdown... Apr 8 16:38:40 black mysqld[4753]: 070408 16:38:40 InnoDB: Shutdown completed; log sequence number 0 43655 Apr 8 16:38:40 black mysqld[4753]: 070408 16:38:40 [Note] /usr/sbin/mysqld: Shutdown complete Apr 8 16:38:40 black mysqld[4753]: Apr 8 16:38:40 black mysqld_safe[4827]: ended Apr 8 16:38:54 black /etc/init.d/mysql[5026]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Apr 8 16:38:54 black /etc/init.d/mysql[5026]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Apr 8 16:38:54 black /etc/init.d/mysql[5026]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Apr 8 16:38:54 black /etc/init.d/mysql[5026]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Apr 8 16:38:54 black /etc/init.d/mysql[5026]: ----
I think the problem is that when mysql starts, the NewokManager did not finish to configure the interface (in my case eth0 - 192.168.0.4), and so mysql can not bind to that interface. Mysql should start only when the network is available. (see also http://ubuntuforums.org/showthread.php?t=403222 - I think this is the same bug) ** Affects: network-manager (Ubuntu) Importance: Undecided Status: Unconfirmed -- mysql fails to start when bound to an address that is not 127.0.0.1 https://bugs.launchpad.net/bugs/104466 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
