When adding a new MySQL monitor, i get a message "The MySQL Server is not accessible from the Applications Manager Server host.Kindly add permissions ..."

When adding a new MySQL monitor, i get a message "The MySQL Server is not accessible from the Applications Manager Server host.Kindly add permissions ..."

Reason: In the MySQL database (that you are trying to monitor), the user name used to run 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 above privileges 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.

  • In the host where the MySQL (which you are trying to monitor) is running, connect as a root user.
  • Execute the following commands.
If MySQL version is below 5.7:
To create a new user in mysql database:
  1. USE mysql;
  2. INSERT INTO user (Host,User) VALUES('<host>','<user>');
Granting privileges required for DB-user to monitor MySQL DB-sever:
  1. GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
  2. FLUSH PRIVILEGES; (Use the host name - Applications Manager machine).
If MySQL version is 5.7:
To create a new user in mysql database:
  1. USE mysql;
  2. CREATE USER <user>@'%' IDENTIFIED BY 'password';
Granting privileges required for DB-user to monitor MySQL DB-sever:
  1. GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
  2. FLUSH PRIVILEGES; (Use the host name - Applications Manager machine).
If MySQL version is 8.0 and above:
To create a new user in mysql database:
  1. USE mysql;
  2. CREATE USER '<user>'@'<host>' IDENTIFIED WITH mysql_native_password BY 'password';
Granting privileges required for DB-user to monitor MySQL DB-sever:
  1. GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
  2. FLUSH PRIVILEGES; (Use the host name - Applications Manager machine).
NOTE: Execute the file MySQLDebug.bat under AppManagerHome\bin\troubleshooting and send the result.