All versions of Macromedia ColdFusion MX include a MySQL JDBC Type 4 driver. However, some users may choose to use more recent MySQL JDBC drivers distributed by MySQL in order to use newer features of MySQL.
This TechNote describes how to configure ColdFusion MX to use a newer version of the driver.
Connector/J version 3.1 release 3.1.11 or 3.1.12 cannot be used with ColdFusion MX 7 because of mySQL Bug 13469. Connector/J 3.1.13 fixes this bug, so driver version 3.1.10 or 3.1.13 should be used. All Connector/J version 3.0 releases and all (currently beta) version 3.2 releases work with ColdFusion MX 7.