I am not able to connect to the mysql DB if I am not the root user. I
have already found identified an issue:
* mysql.sock is NOT located in /tmp
So, to get around it I created a sym link to the actual location
(/var/lib/mysql/mysql.sock). This file, and the sym link, are both
owned by root but they have full permission for all user. But the
parent directories are ONLY READ and EXECUTABLE for non root users.
If I change the permissions on:
* /var
* /var/lib
* /var/lib/mysql
I am able to connect to mysql (from both command line and my PHP
script). But I really don't want to leave it so open.
Any ideas how to get around this? I'm thinking the best solution would
be to make mysql create the .sock file in /tmp so that I don't have to
create the sym link. But I an open for any / all suggestions.
TIA.
- manzoor