adding MySQL gets error MYQL is not accessible

Reason: In the MySQL database (that you are trying to monitor), the user name assigned to Applications Manager should have the permission to access the MySQL database from the host where Applications Manager is running.

Solution: A relevant user who has the privileges to do the same should be set. To provide permission for a specific user (of the host where Applications Manager is running) to access the MySQL server, follow the steps given below.

1. In the host where the MySQL (which you are trying to monitor) is running, connect as root user.

2. Execute the following commands.

USE mysql;
INSERT INTO user (Host,User,Password) VALUES('<Applications Manager Host>','<user>',PASSWORD('some_pass'));
GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON *.* TO '<user>'@'<Applications Manager Host>' identified by 'some_pass';
FLUSH PRIVILEGES;

Example:

USE mysql
INSERT INTO user (Host,User,Password) VALUES ('jean.corp.com','root',PASSWORD('some_pass'));
GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON *.* TO 'root'@'jean.corp.com' identified by 'some_pass' ;
FLUSH PRIVILEGES;
[where, 'jean.corp.com' is the Canonical Host Name and 'root' is the user and 'some_pass' is the password]

NOTE: Execute the file MySQLDebug.bat under AppManagerHome\bin\troubleshooting and send the result to appmanager-support@manageengine.com