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:
This error occurs because the MySQL user account provided for monitoring does not have the necessary privileges to connect from the specific IP address or hostname where the Applications Manager server is installed.
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 8.0 and above:
To create a new user in MySQL database server:
- USE mysql;
- CREATE USER '<user>'@'<host>' IDENTIFIED BY '<password>';
Granting required privileges to a database user for monitoring:
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- FLUSH PRIVILEGES;
Notes:
Replace <user> with the MySQL username used for monitoring.
Replace <host> with the IP address or hostname of the server where Applications Manager is installed.
Replace <password> with the password for that specific MySQL user.
If MySQL version is 5.7
To create a new user in MySQL database server:
- USE mysql;
- CREATE USER <user>@'<host>' IDENTIFIED BY '<password>';
Granting required privileges to a database user for monitoring:
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- FLUSH PRIVILEGES;
If MySQL version is below 5.7
To create a new user in MySQL database server:
- USE mysql;
- INSERT INTO user (Host,User) VALUES('<host>','<user>');
Granting required privileges to a database user for monitoring:
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- FLUSH PRIVILEGES;
Note:
If the error persist despite implementing the above changes, please run the MySQLDebug script by following the steps outlined in this KB article and provide the output to our support team for further assistance.
New to ADSelfService Plus?
Related Articles
Mail Server Monitor - Troubleshooting
Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...Troubleshooting URL Monitor
When configuring a URL monitor in Applications Manager, you might encounter several errors related to accessibility, configuration, or server-side issues. Below are common errors along with step-by-step troubleshooting instructions to help you ...Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Solution: To overcome this issue follow the steps given below: Execute the following query in the corresponding MySQL shell script: ALTER USER ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the below steps for troubleshooting. Step 1: Check the RUM Agent configuration Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer this help ...