Problem with making DSN

[Tivoilos]

I get this error everytime I try an make a DSN

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

[Owainnorth]

Have you tried connecting to the server by other methods, perhaps the MySQL commandline client from the CF box?

Does the database run on the same server or a different server?

If different - firewall? Does MySQL allow remote connections?

[Tivoilos]

I am using WAMP server 2 which contains MySQL 5.4.01 or whatever version I am running so it is running on the same server.