Having trouble connecting to mysql 5 ..... Please help...

[myjeep]

I am not sure what is wrong but I am stuck and some help would be appreciated. I am running ColdFusion Version 9,0,1,274733  Enterprise Edition on Linix 6x with apache connector. I am running 3 instances of ColdFusion. I fire off cfusion like this ./jrun start cfusion . I am using Mysql is mysql 5.1.31sp1- enterprise. Then I use the web browser to connect to the admin portal. Everything works but I cant connect the mysql datasource. I get the follwoing screen.

Connection verification failed for data source: weblive

  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.

I can connect to mysql using the GUI admin or command line No problem......It is running on port 3306.

Please help....................

[Charlie Arehart]

Just as one possible issue, when you say you “can connect to mysql using the GUI admin or command line No problem”, are you doing that from the machine on which you are running CF? Because if you’re doing it from, say a laptop, and CF is on another box, it could be that you have a firewall on the machine running MySQL, and it’s been opened to your laptop but not your server.

I realize this may be “all on one box”. Just had to ask. If that’s the issue, maybe someone else will recognize another problem/solution.

/charlie