I can connect on the command line, but have problems connecting using DBI/D
on the same server.
# ./bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.0-alpha-standard
Mysql is running
# ps -ef | grep mysql
root 10626 9589 0 11:57 pts/341 00:00:00 /bin/sh ./bin/mysqld_safe
mysql 10642 10626 0 11:57 pts/341 00:00:00 /usr/local/mysql/bin/mysqld
--defaults-extra-file=/usr/local/mysql/data/my.cnf --bag
...
I can connect at the command line
# ./bin/mysql -username=hcspt
Welcome to the MySQL monitor. Commands end with ; or \g.
When I connect using perl on the same server the following error occurs
...failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'...
Ive noted that mysql.sock is not in the location in the same directory as
the above error message
# find / -name mysql.sock
/tmp/mysql.soc
Setting the location of mysql.sock in my.conf
[client]
socket = /tmp/mysql.sock
Causes error
Any suggestions?
Thanks
Terry
