when I'm running command line, mysql expects mysql.sock to be located in /tmp, but when I connect via myodb, it seems to be looking in /var/lib/mysql/
I'm getting the same problem in php and chili!soft asp:
ADODB.Connection.1 error '80004005'
SQLState: S1000
Native Error Code: 2002
[TCX][MyODBC]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
/conn.asp, line 4
I've gotten a connection working in php using the standard code $db_conn = mysql_pconnect("localhost", "login", "password") or die(mysql_error ()); but there is an existing ASp application that is now broken...
I've tried editing the odbc.ini files, and it hasn't worked...and I can't write to the data dir via ftp, and pico and vi are broken in the command line, so I can't create a my.cnf file in the data directory...
help!!
thanks
