Re: How do I connect ColdFusion Admin to MySQL

[Azadi <azadi@xxxxxxxxxxxxx>]

have you installed mysql and verified it is running?

mysql is NOT a file-based db - there is no FILE to put in any FOLDER.
mysql is a DB SERVER - it runs on a certain server on a particular PORT
(default is localhost:3306), under a username and password combination
you set up. once you have mysql installed, this is all you need to tell
cf to connect to a mysql db: server and port, username and password.

make sure you set up users and grant them only basic permissions
(select, insert, update and possibly delete) for your db's in myslq and
then use those users' credentials for the cf dsn setup - do not use the
ROOT user with all privileges for your cf DSNs.

in light of recent cf-targeted sql injection attacks i will advise you
to run mysql in NO_BACKSLASH_ESCAPES mode.

mysql.com has very good online and downloadable docs.

hth


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/