FW: Problems with mysql.sock

Hi

I need to know how and where to tell mysql to look for mysql.sock.

I am using mysql version 3.23.55 and SUSE Linux 8.2.

My problem is that i have a mysql daemon working very well and using /var/lib/mysql/mysql.sock as the correct socket. No problems.

My problems come when I try and install the perl msql-mysql modules.

It asks for my mysql directory, which is /usr/local/mysql/.

I can only assume that it then tries to execute /usr/local/mysql/bin/mysql, and guess what? For some reason it tries to connect through the default /tmp/mysql.sock, which doesn't exist and everything fails.

SO whats going on? Why, when i execute /usr/bin/mysql does mysql look to /var/lib/mysql/mysql.sock and when I execute /usr/local/mysql/bin/mysql, does it look to /tmp/mysql.sock? How can I set BOTH to look at /var/lib/mysql/mysql.sock?

I tried mysql_config --socket /var/lib/mysql/mysql.sock, but all that does is repeat the usage message for mysql_config.

So when I try to connect through DBI, I get a "cannot connect through /tmp/mysql.sock" error message. But the mysql on my computer, the daemon that is up and running, always connects through /var/lib/mysql/mysql.sock. I even have that set in /etc/my.cnf.

Help me, I am confused!

Thanks
Mick

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org