[Zope-DB] Can't connect to MySQL database

Kolari S. Bhat kolari.s.bhat@vanderbilt.edu
Mon, 21 Oct 2002 11:44:39 -0500

I have the following setup:
RedHat Linux 7.3
Zope 2-6-0 installed and working.
MySQL 4.0.4 installed from RPM; tested, works.
ZMySQLDA installed from ZMySQLDA-2.0.7.linux-i686.tar.gz

I started MySQL server; started Zope; opened Zope from a web browser (as 
localhost).  I would like to add a Z MySQL Database Connection object in 
Zope.  For Database connection string, I used the following format:
    test user_name user_password

I am getting the following error:

Error Type: OperationalError
 Error Value: (2002, "Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)")

Do I need to change ownership of /var/lib/mysql? If so what sort of 
ownership should this directory have?
Thanks in advance for any help.