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
Below is mySQL settings:
Help me save what little hair I have left and connect to mySQL server.
Have you tried conecting to MySQL with any other software? (The problem might not be with CF)
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.