Ok, I tried creating the directory and no change.
phpMyAdmin gives this explanation of the error:
#2002 - The server is not responding (or the local MySQL server’s socket is not correctly configured)
Which makes sense since the error message from php says it can’t open it at /var/run/mysql so no socket exists.
How does the socket come into being?
I have uninstalled and reinstalled mysql gui tools and loaded the share instead of the share-compat to make sure the libmysqlclient15 is no longer there. Rebooted, and no difference.
The MySQLAdministrator gives much information, but I don’t know what to look for. It is using /var/lib/mysql/mysql.sock.
(Hmmmm…)
Looking at mysqld --help --verbose shows that the socket is /var/lib/mysql/mysql.sock (which we already knew).
Looking at /var/lib/mysql/(server).err shows
[Note] Plugin ‘FEDERATED’ is disabled.
InnoDB: Started; log sequence number 0 44323
[Note] Event Scheduler: Loaded 0 events
[Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.1.39’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server (GPL)
Hmmm… Everything seems to work that is using the /var/lib/mysql/mysql.sock but some programs don’t work that use /var/run/mysql. Those two programs that I’m trying to use both are PHP programs. Looking at /etc/php5/php.ini has
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =
Built in? As in my issue is maybe with php? It’s 5.3. So, somehow it was using /var/lib, but now is using /var/run. How does it know that? Something is telling it to use 11.2’s /var/run. It’s hard to do a system search for where it’s set when you realize it could be something like $datadir/mysql.sock.
Should I try to make the system “built in” to point to /var/lib or the other programs point to /var/run? Don’t want to create more issues. Maybe if I create a my.cnf file and say socket = /var/lib/mysql/mysql.sock will fix it and any other issues? Or set php.ini to socket=…/var/lib/mysql/mysql.sock (or what?). What is best?