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) ...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 ...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 ...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 ...