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!