Hi,

I've installed MySQL 5.0.24a-standard on my AMD 64, SuSE 10.0 box, using the binary distribution from the MySQL downloads site. I've also installed the GUI tools from the same location, using the SuSE 10.x rpm packages. The intention is to use MySQL with PHP5 and Apache. Both these latter have been installed from the SuSE rpm files supplied on DVD with SuSE 10.0. I have a couple of problems.

Firstly, PHP seems to want the mysql.sock file to be in /var/lib/mysql/mysql.sock - at least this is the location given by phpinfo() - instead of /tmp/mysql.sock. This location appears to be contained in an environment variable called MYSQL_SOCKET, but I can't find where it is set. One solution would be to get MySQL to put the mysql.sock file in the place expected by PHP. Is this possible?

At the moment, I have a /etc/my.cnf file with the following content:

[mysqld] socket=/tmp/mysql.sock

[client] socket=/tmp/mysql.sock

I added these entries in an attempt to get PHP to use the actual location that MySQL is using, but this doesn't appear to have had any effect (according to phpinfo()).

Secondly, MySQL appears to be trying to write logs to /var/log/mysql (according to MySQL Administrator). This location does not exist. I'm getting no error messages, but presumably this means I'm not getting any logs either. Should I create this location and if so, what permissions and ownership should I give to the directory?

Thanks in advance