HOWTO: Add MySQL 5 Driver Support To Coldfusion 11

If you do any work with Adobe Coldfusion, when Coldfusion 11 was released, one of the items missing from Coldfusion 11 was database driver support for MySQL 5 community server, trying to add a datasource ended in an error messaging simply instructing the user to download and install the driver.

My first thought to tackle this issue was simple – turn to Uncle Google and see if there is an howto written on this… but at last, after reviewing the results, no HOWTO was found. So I promised myself to write a HOWTO if I ever figure it out, and here I am.

All that is needed is a .JAR file and it needs to be placed in the CFroot/lib directory. After some searching, I discovered that the MySQL’s Connector/J is the official JDBC driver for MySQL and this is exactly what is needed for this problem.

Here are the steps:

  • Downloaded the file from http://dev.mysql.com/downloads/connector/j/
    # wget “http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.34.tar.gz”
  • On Centos 6, extract out the JAR file and drop the file on the server in: /opt/coldfusion11/cfusion/lib
    # cp mysql-connector-java-5.1.34-bin.jar /opt/coldfusion11/cfusion/lib
  • Changed ownership and priv on the file so the web server can access/run it
    # chown apache.bin /opt/coldfusion11/cfusion/lib/mysql-connector-java-5.1.34-bin.jar
    # chmod 0700 /opt/coldfusion11/cfusion/lib/mysql-connector-java-5.1.34-bin.jar
  • Restart Coldfusion
    # service coldfusion_11 restart

After Coldfuion 11 is restarted, add your MySQL 5 datasource and you are finished!