I've just installed MySql to support a mediawiki install on 12.04 64bit. Everything appears to be working ok, except that at boot-up, mysql server fails to start. This results in an error appearing on the webpage:
Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock
When I discover this, and run
sudo service mysql start
It all works ok after that until the next reboot.
I can't figure out what is going on.
There appear to be several similar issues being reported, however most of these appear to be outright failure to start - i.e. manual start or on boot-up fails. I haven't seen anything relating to a "transient" error like this.
For the record, I've got a fairly standard install - I didn't fiddle with settings - just the bind address in /etc/mysql/my.cnf
I thought maybe something to do with drive mounting, but datadir is on /var
which is on the main partition.
any clues? Suggestions even for a workaround?
Only workaround I'm toying with is to set a cronjob at intervals of every half hour or so.