# Coldfusion and mySQL error

**URL:** <https://forum.kirupa.com/t/coldfusion-and-mysql-error/186065>\
**Category:** programming\
**Created:** [April 18, 2006, 7:46pm UTC](https://forum.kirupa.com/t/coldfusion-and-mysql-error/186065 "2006-04-18T19:46:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![AgentFitz](https://avatars.discourse-cdn.com/v4/letter/a/f17d59/32.png) [@AgentFitz](https://forum.kirupa.com/u/AgentFitz)\
**Post date:** [April 18, 2006, 7:46pm UTC](https://forum.kirupa.com/t/coldfusion-and-mysql-error/186065/1 "2006-04-18T19:46:52Z")

</div>

Welcome to my wild goose chase over the last week :pirate3: I am having a beast of a time trying to get Coldfusion to work properly with mySQL.

After successfully creating a database and specifying log-in and password, I tried to register the database through the ColdFusion administrator and received the following error:

[SIZE=1][COLOR=red]Connection verification failed for data source: learningcoldfusion[/COLOR][/SIZE]  
[SIZE=1][COLOR=red]java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? [/COLOR][/SIZE]  
[SIZE=1][COLOR=red]The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?[/COLOR][/SIZE]

Then…I was directed to this link:

[COLOR=#464646][http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253](http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253)[/COLOR]

which I followed explicitly, only to receive this error:

[SIZE=1][COLOR=red]Connection verification failed for data source: learningcoldfusion [/COLOR][/SIZE]  
[SIZE=1][COLOR=red]java.sql.SQLException: No suitable driver available for learningcoldfusion, please check the driver setting in resources file, error: null [/COLOR][/SIZE]  
[SIZE=1][COLOR=red]The root cause was that: java.sql.SQLException: No suitable driver available for learningcoldfusion, please check the driver setting in resources file, error: null[/COLOR][/SIZE]

Basically, ColdFusion administrator will not let me register my “mySQL” database as a data source, even though mySQL has told me that it was created successfully. why might this be? has anyone come across this??

Fitz