Hi,
My OS is Windows Vista home premium service pack 2, I am trying to set up a connection to a MySQL database version 5.1. I started the openOffice.org 3 database wizard and I followed the steps:
- select database: I choose connect to an existing database "MySQL"
- set up a connection to a MySql database: I choose "directly"
- set up my SQL server data: I put in my database name, then server: "local host", then port: 3306
- set up user authentication: in the user name field I put root and checked the "Password required" box.
then I pushed the buttton "Test Connection", I was then prompted to enter the password, and after a while received an error msg "can't connect to MySql server on localhost (10061)".
I have the latest versions: OpenOffice.org 3 and MySQL 5.1 (both downloaded this week).
Before that I downloaded the MySQL connector for openOffice.org (choosed windows).
I created my database using the my SQL command line client and I verified with the command "show databases"; it was fine: the database name appeared along with two other databases: mysql and test.
I checked my user name with the command select user(); and obtained root@localhost.
I tried it many times and I always get the same error msg.
I really can't figure out what went wrong.
Thank you for your help.
Ben.