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
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 prerequisites to be done Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...Troubleshooting URL Monitor
Here are few of the common errors you may come across in URL monitor, we have mentioned the steps you can follow to troubleshoot them. General troubleshooting for URL monitor Ensure that the URL is accessible from the server in which Applications ...IIS Server monitor - Issues encountered while adding an IIS server monitor
Unable to add an IIS server monitor Prerequisites: Make sure you have performed all the prerequisites for the IIS server monitor. Follow the steps mentioned below to add an IIS server monitor: IIS Server URL accessibility: Check whether the IIS ...