![]() ![]() Enter the port number in which MySQL is running.Check the ' Force SSL' box to force an SSL connection. ![]() Enter the IP Address or hostname of the host.To create a MySQL database server Monitor, follow the steps given below: Using the REST API to add a new MySQL DB monitor: Click here Prerequisites for monitoring MySQL DB metrics: Click here GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON *.* TO PRIVILEGES INSERT INTO user (Host,User) VALUES('','') Also, Applications Manager machine should be allowed to access the MySQL database server.įor enabling the privileges, execute the below commands in the remote MySQL Server Minimum User Privileges : The user should have privileges to execute SELECT, SHOW DATABASES, REPLICATION commands in the MySQL server. Else, give a relevant user who has the privileges to do the same. Note: In the MySQL database (that you are trying to monitor), ensure that the user name assigned to Applications Manager has the permission to access the MySQL database from the host where Applications Manager is running.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |