coldfusion 6 with mysql 5.6.x on linux : communication error during handshake

coldfusion 6 with mysql 5.6.x on a linux box (i use centos)

adding a datasource in coldfusion using mysql driver will get you:
[]java.sql.SQLException: Communication failure during handshake...

to fix:

1. download mysql-connector-java-3.0.17-ga.tar.gz (using connector 5.x didnt work for me)
2. extract and copy mysql-connector-java-3.0.17-ga-bin.jar to /opt/coldfusionmx/wwwroot/WEB-INF/lib/
3. add classpath /opt/coldfusionmx/wwwroot/WEB-INF/lib/ in cf admin

4. restart cf
5. add datasource using other driver

jdbc url: jdbc:mysql://<host>:<port>/<database name>
driver class: com.mysql.jdbc.Driver

booyah!!

(reference: http://helpx.adobe.com/coldfusion/kb/configure-jdbc-driver-mysql-4.html)

mysql: error code 1034 incorrect key file for table

this error was displayed while trying to access one of my tables

MySQL error code 1034 (ER_NOT_KEYFILE): Incorrect key file for table '%-.200s'; try to repair it

both # myisamcheck -o <table name> and mysql> repair table <table name>; didn't work.

had to recreate my table from an sql dump file xP

mysql: cant remote 1042

if you get a 'cant remote' 1042 in mysql

add this to your mysql configuration file my.cnf:
[mysqld]
skip-name-resolve

mysql: server installation - quit without updating file error

can't install MySQL server on CentOS

MySQL... ERROR! Manager of pid-file quit without updating file.

disable selinux in /etc/selinux/config