Ubuntu
mysql-dfsg-5.0 package

Rebooting breaks MySQL-Server

Bug #29786 reported by Chris Peterman
6
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.0 (Ubuntu)
New
Medium
Unassigned

Bug Description

mysql-server-5.0 installs fine, works fine. Until I reboot the machine. Upon reboot it seems to come up fine, but I cannot connect to the server (localhost), the error being something like "cannot connect to local MySQL server through /var/run/mysqld/mysqld.sock"

However, purging mysql-server-5.0 (and answering no to the question about deleting other databases) and then reinstalling it seems to bring it back without any data loss

Revision history for this message
Chris Peterman (kyral) wrote :

I should add that nothing can connect to the database either. phpmyAdmin, wordpress, nada. However, oddly, if I do sudo -i then try mysql -u root it connects..

Revision history for this message
gregwa (gregwa) wrote :

the bug has to due with a permissions issue for /var/run/mysqld. by default it is being set to drwxrwx---, which does not allow a "normal" user access. This being said, it only holds until the next reboot at which time it will then be reset. workaround is to either change the permissions everytime a reboot is done, or add a line to /usr/share/mysql/debian-start right after the 'source /usr/share...' to say 'chmod a+x /var/run/mysqld/'. (Thanks to cmoad on the ubuntuforms for the workaround).

Revision history for this message
Jonathan Wagener (jontyw) wrote :

i find that using the default UNIX/Linux shutdown sequence (using the one that gnome/kde provides) breaks the mysql server. use init 0 that does not break the the mysql server.

is there a reason that mysql breaks, is it a unix bug or is it a mysql bug?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.