How do I troubleshoot a MySQL Database Collector that will not start?

[#1]

For users whose MySQL database collector will not start, first check the configuration data including username, password, host, and port.

Look in the Agent logs for an error similar to the following:

"Error collecting data for database 'xxx DB' java.sql.SQLException: Access denied for user 'root'@'hostname'"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) 
 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004) 
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284) 

To diagnose this issue, first validate the following:

1. Telnet to the MySQL database from the Database Agent host with the data provided in the collector. ($telnet hostname port)
2. If the Telnet works but the collector returns an "Access denied" error message, follow the next steps.
   1. Run the following command in MySQL database: mysql> select user, host from mysql.user where name = 'root';
   2. Note: root is the user for which the error occurred in the collector start up.
   3. Validate whether the user that is mapped to the hostname provided in the collector configuration matches the output(host) of the previous command. Both the hostnames should match.

Resolve the issue by either updating the collector configuration to match the MySQL command output from above, or create a new hostname that matches the collector configuration output and use this new hostname in the collector configuration. 

Related Links:

• Configure MySQL Collectors

• MySql: Give Root User Logon Permission From Any Host