What's wrong with this MySQL connection? "Could not create connection to database server"

Question

I'm able to connect to other MySQL databases but this one particular remote MySQL connection isn't working and I cannot figure it out. It probably has something to do with the remote server, not CF, but I thought I'd post it here if anyone had an idea. The MySQL account has full priviledges.

Here is the message when I try to validate the data source:

Connection verification failed for data source: test
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Grant7127140 · Answer

This happened on two servers. One one, the cause was that skip-networking was turned on. In the other situation, it appears that the database name was case sensitive, so TEST was not the same as test. Even though I edited the data source in the CF administrator, it still didn't work (very misleading). When a coworker entered a new data source with the same information (uppercase database name this time from the start), it worked.

Has anyone else seen this problem with the case sensitive database names? And with the data source in CF not updating the case correctly? Seems like a bug in CF.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded