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
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
