Neil Merton

ColdFusion and MySQL

Have you ever had the following error when trying to connect to a MySQL database via the ColdFusion admin area?

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

If so, then read the following TechNote to solve the problem.

EMS SQL Manager 2005

Anyone who has had exposure to Microsoft’s Enterprise Manager for SQL Server will know just how awful the software is to use. I got so frustrated with it recently I went on the hunt for an alternative…

EMS SQL Manager 2005 does what Enterprise Manager should do, by default. With EMS SQL Manager you can view databases (whilst hiding the system bits that you’ll never need to access), print out useful stuff (tables, fields, stored procedures, triggers, views etc) and so much more. The interface is very user friendly and well thought-out.

I can highly recommend this software to anyone using SQL Server.