Connecting MySQL ODBC 3.51 to CFMX

Posted by: scoopseven 17 years, 6 months ago

The MySQL ODBC 3.51 driver doesn't like CFMX because CFMX uses the odl MySQL password convention. So, to setup a datasource in CFMX that uses the MySQL 3.51 driver you have to setup a user in MySQL for ColdFusion, then run the following commands (I do it in MySQL Front). SET PASSWORD FOR 'cfuser'@'localhost'=OLD_PASSWORD('password'); SET PASSWORD FOR 'cfuser'@'%'=OLD_PASSWORD('password'); After I do this, because I'm using MySQL Front, I can go look at the this user by clicking on USERS and then click on the Source tab. Copy and paste whatever is in the source tab and modify it to your liking. Here's what I did to give my cfuser complete access to MySQL. GRANT ALL PRIVILEGES ON *.* TO 'cfuser'@'%' IDENTIFIED BY PASSWORD '067747ad23f28fef' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'cfuser'@'localhost' IDENTIFIED BY PASSWORD '067747ad23f28fef' WITH GRANT OPTION; Share on Twitter Share on Facebook

• ← Installing MySQL JDBC driver for ColdFusion MX 6.1
• Incorrect key file for table →