MySql connection error

when trying to connect to a mysql database I get the following error in Coldfusion:

Connection verification failed for data source: zipcodes
java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306?

Does anyone know why this is happening?

 

IS the MySql server running on a remote machine or on your own local computer?

How about the Coldfusion server... Is CF on a remote computer too? And are either running on a shared server/host?

If they are on a shared server/host then you should contact them. On a shared host, the host provider usually has to make the connection work for you when it comes to cf and a database. this is because you don't usually have access to the cfadmin.

If they are on your own local machine then you will just need to login in to your cfadministrator and check to see if you are using the correct driver to connect to your database.

 

Thanks for your help. I am new at coldfusion so don't be afraid to state the obvious...

IS the MySql server running on a remote machine or on your own local computer? - same box as the coldfusion server


I now get this error:

Connection verification failed for data source: zipcodes
java.sql.SQLException: No suitable driver available for zipcodes, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for zipcodes, please check the driver setting in resources file, error: null

This is the settings that I have in literal text:
CF DATA SOURCE NAME: zipcodes
JDBC URL: jdbc:mysql://127.0.0.1:3306/zipcodes
DRIVER CLASS: com.mysql.jdbc.Driver
USER NAME: zip_user
PASSWORD: *****

 

Yeah, Like I said, I think that maybe you dont have the correct driver selected,

You can change the driver if you have access to your coldfusion administrator.

I would find out the exact version of Cf and mysql you are running then do a search on that looked something like this on google:

cfml mysql driver

But besure to include which version of each one you are running.

If you do have access to you cf admin then you should be able to browse to it like this:

http://127.0.0.1:8500/CFIDE/administrator/index.cfm

Or something simalar, but you will need to know the password to login to cf admin.

Then you would select datasource on the left nav bar, then you can look at which driver is setup for your mysql database.

Are you using dreamweaver to built your site?

Did you use dreamweaver to setup your database connection?

 

ColdFusion MX Version: 7.0.091690

MySql : version 5.0.22-community-nt

 

Check out this other blog on Ben Fortas web site. A guy described the same problem.

Heres the link:
http://www.forta.com/blog/index.cfm?mode=entry&entry=A61BD155-3048-80A9-EF63F5397C4511AA


Check out this link as well for more information:

http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7

Sorry I cant be more help, I'm not too familur with MySql, I run my site on MsSql

Good Luck

 

Thanks.

I had downloaded the jar files already and put them in the directories. Not sure If I restarted the server or not. Can someone please tell me how to restart the server. I do have access to coldfusion Admin but dont see a restart option.

 

Try this, found it on a different website

Basicaly goto the control panel on your pc and select administrative Tools

then select Services

then find ColdFusion Application Server,

Then select restart on the left.

 

no error, THANK YOU !!!!!!!!!!!!