After recent upgrade on my Gentoo box I've accidently got /var/run/mysqld directory removed. The socket path pointed there, and, of course, mysqld denied to launch. The same thing happened some time ago on Ubuntu and openSUSE. I've no clue what makes it(mysqld? rc script?) remove the directory. But I've got at least two simple fixes for that and wanna share it in this post.
Fix #1
Just change path to the socket in /etc/mysql/my.cnf and get rid of these upgrade issues:
socket = /tmp/mysqld.sockI have it in client and mysqld sections.
Fix #2
Change the runlevel script. In Gentoo it looks like the following:
checkconfig() { if [ ! -d /var/run/mysqld ] ; then checkpath -d -m 755 -o mysql:mysql /var/run/mysqld fi if [ -z "${MYSQL_PERMS_OK}" ] && [ "$(stat -c %a /var/run/mysqld)" != "755" ] ; then ewarn "mysqld run dir is not world readable, you should reset the perms:" ewarn "chmod 755 /var/run/mysqld" ewarn "To disable this warning, set 'MYSQL_PERMS_OK' in /etc/conf.d/mysql" fi } start() { checkconfig # ... }You should have got it. checkconfig is called on at the very beginning of /etc/init.d/mysql start handler.
That's it. I hope this saves someone's time.