2 Replies Latest reply on Oct 1, 2013 5:11 PM by rickaclark54

    Problem connecting mySQL with CF9 datasource

    rickaclark54 Level 1

      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:

      mysql_connections.jpg

       

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