Latest upgrades have broken MySQL

[utkjamie]

I run Apache and MySQL on my laptop for web development and the latest updates seem to have broken MySQL. When I attempt to start it I get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

The /var/run/mysqld directory doesn't even exist. Since this has never been a problem before, I'm not sure if the directory was previously there and now gone or if it has always been located in a different place.

[utkjamie]

[RESOLVED] Re: Latest upgrades have broken MySQL

Looks like I posted too soon. I was able to to resolve the problem by:

1) Creating a /var/run/mysqld directory and chowning it to mysql:mysql
2) Using touch to create the mysqld.sock file and chowning that to mysql:mysql
3) Restarting /etc/init.d/mysql

Problem solved.

[kilroy]

Re: Latest upgrades have broken MySQL

Mutter - Same problem here Jamie,
I did as you tried - and still no go unfortunately - any other suggestions?
My /var/log/messages shows nothing relating to mysql and the /var/log/mysql.err and mysql.log are empty


Anybody got suggestions?
thanks
Andrew

[utkjamie]

Re: Latest upgrades have broken MySQL

Mutter - Same problem here Jamie,
I did as you tried - and still no go unfortunately - any other suggestions?
My /var/log/messages shows nothing relating to mysql and the /var/log/mysql.err and mysql.log are empty


Anybody got suggestions?
thanks
Andrew

Even the workaround I've been using only works until the next time I reboot, so it isn't much of a solution anyway. Try starting MySQL with: sudo mysqld &

[kilroy]

Re: Latest upgrades have broken MySQL

What I did - was remove mysql 5.0 and then install 5.1

that seemed to fix all the links that were missing and it worked.

Andrew

[utkjamie]

Re: Latest upgrades have broken MySQL

I'm still having problems with this. My workaround works but it's a frustrating to have to do it everything I boot my computer up. From what I can see, I'm already running MySQL 5.1