ColdFusion 9.0 Resources |
Creating a data source in MySQLTo 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. |