Installing Cloudera Hadoop with MySQL for back-end database

At Database setup during the cluster setup, you see this error when you test the connections to the DBs:

JDBC driver cannot be found. Unable to find the JDBC database jar on host :

You need to make sure you get the latest mysql connector jar file and put it here (named this way too):

/usr/share/java/mysql-connector-java.jar (the below error messages say it’s explicitly looking for a file by that name)

In /var/log/cloudera-scm-server/cloudera-scm-server.log I saw this:

+ exec /usr/java/jdk1.7.0_67-cloudera/bin/java -Djava.net.preferIPv4Stack=true -Djava.security.egd=file:///dev/urandom -cp ‘/var/run/cloudera-scm-agent/process/6-HIVE-test-db-connection:/usr/share/java/mysql-connector-java.jar:/usr/share/cmf/lib/postgresql-9.0-801.jdbc4.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/cmf/lib/*’ com.cloudera.enterprise.dbutil.DbCommandExecutor db.properties