If you are new reader, kindly note that this post contains it's first part on post "Installation of MySQL Enterprise Server Manager" . As the second step as mySQL monitor installation we need to install the monitoring agent for each instance. So in order to accomplish that we first need to create a user and grant relevent permission to that user. Create agent user on mySQL mysql> CREATE USER 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass'; mysql> GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS ON *.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass'; mysql> GRANT CREATE, INSERT ON mysql.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass'; mysql> GRANT SELECT ON mysql.inventory TO 'replicationuser'@'%' IDENTIFIED BY 'replication_password'; NOTE : SET SQL_LOG_BIN=0 to stop replicating the below ...
Comments
Post a Comment
Leave a message