Creating a data source in MySQL

To create a MySQL Enterprise ColdFusion data source, select the driver type as MySQL(Datadirect) from the drivers pop up menu in ColdFusion Administrator.

Note: The MySQL5 Enterprise database sometimes requires access permission for all users who try to connect to it, if the access permission is not specified during configuration.

To grant the required permission, you can use the command: grant all on *.* to 'root'@'%' identified by 'admin';.

Replace root and admin by MYSQL username and MYSQL password, respectively.

A new admin API method, setMySQL_DD has been added, which lets you create a MySQL DataDirect data source.