I just had to re-install mysql and I am having a problem starting it up. It cannot find the socket (mysql.sock). The problem is that neither can I. In my Mac OS X 10.4 terminal, I type: locate mysql.sock, and I get back /private/tmp/mysql.sock. It makes sense that the socket file exist in that location, but it actually does not.
How can I find the socket file?
If locate is returning a false location, it must have some sort of memory and probably indexes. How can I refresh that index?
to answer the first part of your question:
run
% mysqladmin -p -u <user-name> variables
and check the 'socket' variable
The socket file should be created automatically when the MySQL daemon starts.
If it isn't found, most likely the directory which is supposed to contain it doesn't exist, or some other file system problem is preventing the socket from being created.
To find out where the file should be, use:
% mysqld --verbose --help | grep ^socket
Unfortunately none of the above have worked in my case. But finally I found solutions.
To find where is mysql.sock file, simply open xampp manager, select MySQL and click on Configure on the right. On the config panel click Open Conf File, and simply search for mysql.sock by pressing the CMD+F shortcut.
In my case, the owner of the mysql.sock was changed, and I had to change it back to root admin with: chmod root:admin mysql.sock
After that the database had been accessed.