Open your Web browser,
and connect to:
Enter your password
in the Password text box.
The ColdFusion Administrator
page will be launched.
On the left menu bar,
under data sources, click ODBC. The ODBC Data Sources Available
to ColdFusion page will be displayed.
To add a mySQL database,
enter the data source name in the Data Source Name text box.
The data source name can be any of your choice.
In the ODBC Drivers
drop down box choose, myODBC mySQL Driver.
Click the Add button
to add the ODBC driver.
The Create ODBC Data
Source [myODBC mySQL Driver] page will appear. This is where
you will set the settings to connect to your database.
The Data Source Name
text box should already be filled out with the name you gave
The Description text
box is where you can give a brief description of the database
The Database Name text
box is for the name of the database you are connecting to.
The Server Host Name
text box is where you will need to provide the name of the server
that your database is on. If your database is on the same server,
than use the default Local Host.
The Server Port text
box should remain 3306. If your database is on a different server
and you know the port number, then make the necessary changes
to the correct port.
Click the CF Settings
A new screen will appear
with some additional information.
The Username and Password
text boxes are where you set the Username and Password for your
Click the Create button
to add the connection.
The ODBC Data Sources
Available to ColdFusion screen will appear. On the right-side
of the screen there should be a Verified next to the Data source
you just added.