Problem connecting mySQL with CF9 datasource

[Guest]

I have been using MSaccess for years and have finally decided to switch to mySQL and have noting bt a basturd of a time trying to figure out how to switch over. I have installed mySQL5 and CF9 developer edition on my test machine at home. try as I might, I cannot connect to mySQL database. I keep getting the following error:

Connection verification failed for data source: test

java.sql.SQLException: Timed out trying to establish connection

The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Below are my settings in the CF admin:

CF Data Source Name: MYSQL_test

JDBC URL: jdbc:mysql://localhost:3306/test

Driver Class: com.mysql.jdbc.Driver

Username: rickclark

password: ************

Below is mySQL settings:

Help me save what little hair I have left and connect to mySQL server.

[EddieLotter]

Have you tried conecting to MySQL with any other software? (The problem might not be with CF)

[Guest]

I was able to access MySQL with the command line client successfully. Actually, I was able to access MS access databases for several years  before I replace my CF8 old machine. When I reisntalled CF8 on my new machine, I receive errors when creating datasources, and told I should try MS access with unicode. So, I thought I would shift from MS access to MySQL installed CF9 to access MySQL, only to arrive at the errors I am currently having.