Skip to main content
A
Anonymous
September 30, 2013
Question

Problem connecting mySQL with CF9 datasource

  • September 30, 2013
  • 1 reply
  • 987 views

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.

    This topic has been closed for replies.

    1 reply

    EddieLotter
    EddieLotter
    Inspiring
    October 1, 2013

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

    A
    Anonymous
    October 1, 2013

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices