GaryAshford
Programmer
Hi.
Lots of people have had a go at addressing the error you get when trying to connect to MySQL from a Linux machine, but none of the answers seem to apply when trying to connect to a REMOTE server via the MyODBC driver.
Why should you get this message when the ODBC DSN in the .odbc.ini file clearly refers to a remote machine, e.g.
[mysql]
driver = /usr/local/lib/libmyodbc.so
server = 194.131.70.164
description = MyODBC 3.51 -> MySQL 4.1
port =
user = gashford
password =
database = mysql
In this situation, what has /tmp/mysql.sock got to do with anything? Windows and Mac clients can connect to the same MySQL server (also running on Linux) without any problems.
I guess there must be a permissions issue somewhere on the client machine which is preventing the ODBC driver from making the connection but I cannot find it. (There is no mysql.sock on the client machine- possibly because this is something you only get on the server??)
Whenever I try connecting using the odbctest utility I get the following error:
[MySQL][MyODBC 3.51 Driver]Can't connect to local MySQL server through socket /tmp/mysql.sock' (2), SQLSTATE = HY000
Any help would be appreciated
Lots of people have had a go at addressing the error you get when trying to connect to MySQL from a Linux machine, but none of the answers seem to apply when trying to connect to a REMOTE server via the MyODBC driver.
Why should you get this message when the ODBC DSN in the .odbc.ini file clearly refers to a remote machine, e.g.
[mysql]
driver = /usr/local/lib/libmyodbc.so
server = 194.131.70.164
description = MyODBC 3.51 -> MySQL 4.1
port =
user = gashford
password =
database = mysql
In this situation, what has /tmp/mysql.sock got to do with anything? Windows and Mac clients can connect to the same MySQL server (also running on Linux) without any problems.
I guess there must be a permissions issue somewhere on the client machine which is preventing the ODBC driver from making the connection but I cannot find it. (There is no mysql.sock on the client machine- possibly because this is something you only get on the server??)
Whenever I try connecting using the odbctest utility I get the following error:
[MySQL][MyODBC 3.51 Driver]Can't connect to local MySQL server through socket /tmp/mysql.sock' (2), SQLSTATE = HY000
Any help would be appreciated