Pricyber wrote:This has been covered several times before--do a quick search in this> I've always used Access and am now switching to MySQL. I installed the server
> which is run locally. I created a new user with full privaleges and a new
> database. I am able to connect to the database via the OBDC just fine. When I
> go into the ColdFusion Administrator (CFMX), I try to add the datasource but I
> get this message:
> Connection verification failed for data source: TEST
> 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?
> I even tried using 127.0.0.1 for my hostname but no success.
> Thanks for your help!
forum and you'll find some info. Also there is a technote about this on
macromedia.com. I'm assuming you're using MySQL 4.1, so if that's true,
the long and short of it is you either need to download the JDBC driver
for MySQL because the one that ships with CF doesn't work with MySQL
4.1, or you need to get into MySQL and rehash your passwords using the
If you poke around and still need help, post again and I'll try to help
Team Macromedia - ColdFusion