CFMX 7 and mySQL 5 configuration

[jkdfjk]

All,

I need help getting the CF 7 admin to recognize mySQL 5 on Windows XP on my
local machine. I know that mySQL is working properly. I'm not familier with
mySQL so I'm not sure where the problems is. Any help would be very appreciated!

Thanks Robert

[mxstu]

I assume you are trying to create a datasource? Can you post your settings and
any error message you receive?

Without knowing your exact problem, I would generally suggest checking the
following:

- Make sure the mySQL service is running (XP may be different, but try:
Control Panel -> Services -> mySQL)
- Verify that you can successfully log into mySQL from the command line
- Make sure any firewalls are not blocking the mySQL port (Typically port 3306)
- Download the appropriate connector jar for mySQL 5 and follow the
instructions here:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

[jkdfjk]

Yes the service is running, I can control data through the command line. I'm
not running any firewalls unless there is something in XP I don't know about.
The error message is this:

Connection verification failed for data source: myDB
java.sql.SQLException: Cannot connect to MySQL server on (local):3306. Is
there a MySQL server running on the machine/port you are trying to connect to?
(java.net.UnknownHostException)
The root cause was that: java.sql.SQLException: Cannot connect to MySQL server
on (local):3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.UnknownHostException)

Thank you for your help!

[mxstu]

I think XP comes with a built-in firewall, so you may need to configure it to
allow access.

The error message sounds like maybe you're using the driver that comes with
MX, which is old. Try following the instructions in the link I posted above.

You will need to download the mySQL Connector jar. I think the current
stable version is 3.1.11, but some people have had problems with it, due to
[url]http://www.sargeway.com/blog/index.cfm?mode=entry&entry=62[/url]. I would suggest
trying another version first. I'm currently using mySQL 4.1, but have had
success with both 3.1.17 and 3.1.19. I think both versions work with mySQL 5
as well.

You can find other versions of the jar at most of the FTP mirror sites listed
on the mysql.com site. For example:

[url]ftp://ftp.orst.edu/pub/mysql/Downloads/Connector-J/[/url]
[url]ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/Connector-J/[/url]

[jkdfjk]

I just want to say thanx for your help I finally got CF to recognize MySQL. I
haven't actually performed a query but I'm sure it will work. Your instructions
helped fix the major problem but I also found that my username wasn't correct.
If you don't assign a username MySQL will assign "root" as the default. As soon
I completed your directions and enter "root" as the username, both CF and
Dreamweaver verified the connection.

Again thank you so much!