Re: help : Problem in connection(python with mysql)

[Jim Winstead]

You may need to provide an explicit path to the UNIX socket for MySQL if the client library that MySQLdb was compiled against has a different default than where the server is placing it.

If you can connect to the server using the mysql command-line client, you can figure out where the server's socket is by using "SHOW VARIABLES LIKE 'socket'"

Then your connect call will look something like:

conn = MySQLdb.connect(host="localhost", user="root", passwd="testpass", db="ex_site", unix_socket="/path/to/socket")

Hope that helps!

Jim Winstead
MySQL/Sun