I need to access a MySQL db from ColdFusion web side 7/8. Web and sql server are on different machines. To access the db, I created an user with phpMyAdmin and tested it on the mysql server by "mysql -u _user_name_ -p" which works. The firewall on the sql server is open.
To connect with CF the code as described at http://tutorial421.easycfm.com/
The connection give the error "Server configuration denies access to data source".