The following article shows what are the minimal privileges required for monitoring only. The follow functionality WILL NOT WORK with the minimal privileges:
- add node (granting is needed)
- create users from UI
- setup replication slave
Replace ADDRESS_OF_THE_CONTROLLER,CMON_PASSWORD, and ADDRESS_OF_THE_DATA_NODE.
mysql -ucmon -p -h<ADDRESS_OF_THE_DATA_NODE>
DELETE FROM mysql.user WHERE user='cmon' AND host='ADDRESS OF CONTROLLER';
GRANT SUPER, SHOW DATABASES, REPLICATION CLIENT, PROCESS, SELECT, RELOAD ON *.* TO 'cmon'@'ADDRESS_OF_THE_CONTROLLER' IDENTIFIED BY 'CMON_PASSWORD';
service cmon restart
Thanks for Sharing a wonderful content. It was very interesting. post regular updates.
Please sign in to leave a comment.