Hi all, I have a problem with my LAMP server. I can’t seem to access mySQL from within a browser. It works fine from a terminal, but from a browser, nothing. This is a fresh install of OpenSUSE 11.0, and I don’t think I’ve done anything wrong. if I did, I would just reinstall again. Anyhow, when I try to run phpMyadmin, I get this…
Error #2002 - The server is not responding (or the local MySQL server’s socket is not correctly configured)
Could somebody please help me sort this out? I’ve already looked through a tonne of forum posts, and have found nothing useful, other than confirmation that I am not the only one having this problem. Please and thank you.
It seems some people have been picking up 5.1 from the bleeding edge repos without realising it, where the socket file was moved to /var/run/mysql, when it used to be in /var/lib/mysql in the 5.0 mysql package from the official repo, which works out of the box with phpMyAdmin from the PHP applications repo.
Apparently it’s not sufficient to just change the paths. On a RHEL system, upgrading to 5.1 requires a new libmysqlclient.so.16 also. The same might also be true on openSUSE. So to avoid hassles, stick to 5.0 unless you badly need 5.1.