Coldfusion Administration:Adding Data Sources Error


* connection verification failed data source: online_store
[]java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?
the root cause that: java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?

thats message when try add mysql database using coldfusion admin page. never error when add access database.

where going wrong?

could or suggest something?

1) mysql server running? localhost:3306 standadr port mysql. if have changed port number during mysql installation should change in dsn string in cf well. mysql server either not running or not configured properly.
2) mysql driver using? if trying set dsn standard mysql 3.x driver shipped cf, may have problem. go mysql.org , download latest mysql connector/j + instructions on how install , how configure dsn. bet not have error updated driver if mysql running , configured properly.


More discussions in ColdFusion


adobe

Comments

Popular posts from this blog

Thread: PKI Client 5.00 install (for eToken Pro)

ATmega2560-Arduino Pin Mapping

Crossfader Arduino Tutorial