How do I make a connection to a MySQL database using ColdFusion?

Question

I have Adobe ColdFusion 10 installed on my computer and registered with a free website on 000webhost.com. However, when I tried to connect I got this error:

Connection verification failed for data source: ssss
java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection

This is what I typed in the ColdFusion connector:

• CF Data Source Name: ssss
• Database: a9156701_25
• Server: mysql3.000webhost.com Port 3306
• Username: a9156701_sayood
• Password: *******

I don't know if the problem is with the free web host or the way I added the data source.

Answer 1

Your datasource looks correct. You are not allowed to connect remotely to the database. I found this mentioned in their forums:

11-12-2013, 05:45 PM: Are you trying to connect remotely? (not allowed) Your files have to be on the server.