i created the db using
SOURCE /tmp/Ambari-DDL-MySQL-CREATE.sql on the remote mySQL DB but I didnt install mysql-connector-java using yum because that server doesnt have internet connectivity. So I copied the
mysql-connector-java-5.1.17.jar file from another cluster which is working. I also checked the symlink to see if it is pointing to the right mysql jar ..
I dont have mysql client on the local ambari host to test the connectivity but i was able to check the connection on the port 3066
FALBDCDQ0001V:~#nc -tz FALBDCDQ0007V 3306 Connection to FALBDCDQ0007V 3306 port [tcp/mysql] succeeded!