Dave Barton ha scritto:
I have installed the MySQL Extension For OOo Extension Version 1.0 in OOo 3.2 and I have a working MySQL database called "testdb" in the /var/lib/mysql directory.Here are the steps I am using to try and connect to my database: o Start Database Wizard. o 1. Select "MySQL" from "Connect to an existing database". o 2. Select "Connect directly". o 3. Database name: testdb Server: localhost Port: 3306 o 4. User name: root Password required: Checked Click Test Connection Enter the MySQL password and click OK. Result: SQL Status: HY000 Error code: 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I get the same result running Base as either root or user. I searched and read everything I can find on using this extension. Can anyone suggest where I am going wrong. TIA Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Ensure networking is enabled in MySQL. For security reasons, most distros configure it so that it accepts connections only through the unix socket (i.e., no tcp/ip connections are possible to the mysql server). Otherwise, check that the path to the mysql socket is the same in the mysql configuration and in OOo (I don't know how to check the latter though, sorry.)
HTH -- Marcello Romani --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
