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:- USE mysql;
- INSERT INTO user (Host,User) VALUES('<host>','<user>');
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- FLUSH PRIVILEGES; (Use the host name - Applications Manager machine).
If MySQL version is 5.7:
To create a new user in mysql database:- USE mysql;
- CREATE USER <user>@'%' IDENTIFIED BY 'password';
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- 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:- USE mysql;
- CREATE USER '<user>'@'<host>' IDENTIFIED WITH mysql_native_password BY 'password';
- GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO '<user>'@'<host>';
- FLUSH PRIVILEGES; (Use the host name - Applications Manager machine).
NOTE: Execute the file MySQLDebug.bat under AppManagerHome\bin\troubleshooting and send the result.
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) ...Self monitor Applications Manager using APM Insight Java Agent
Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the steps below 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 the help ...DNS Monitor - Troubleshooting
Common DNS Monitor Errors and Troubleshooting Guide 1. Host Not Found Description: The DNS server was unable to locate the requested lookup address. Possible Causes: This may happen if the hostname is incorrect, the domain does not exist, or there is ...