I just wasted literally hours of precious time trying to set up the developer edition of CF MX7 to connect to my MySQL 5.1 server by following the (incorrect) instructions that appear all over the internet, including the Adobe support site.
These are the correct steps:
- Download the MySQL connector J verison 3 here
- Extract the connector file mysql-connector-java-3.1.10-bin.jar into the <cfroot>/runtime/lib folder NOT the <cfroot>/WEB-INF/runtime/lib folder as described in many other places on the internet.
- Restart the CFMX7 server
- In the CF administrator create a new datasource of type ‘other’
- Enter
jdbc:mysql://[mysql erver]:[port]/[database]
into the JDBC URL field
- Enter
com.mysql.jdbc.Driver
into the Driver Class field
- Enter MySQL user name and password
- Submit the new datasource
That should do the trick.