Description:
https://enterprise.mysql.com/docs/monitor/1.2/en/mem-install-agent.html#mem-agent-rights
Monitoring server version >5.1.24 - it now needs the PROCESS privilege to run SHOW ENGINE INNODB STATUS;
Can the docs be updated to reflect this difference?
http://dev.mysql.com/doc/refman/5.1/en/innodb-monitor.html
"As of MySQL 5.1.24, the |PROCESS| privilege is required to start or stop the |InnoDB| monitor tables."
The docs state that its a requirement to 'stop or start the innodb monitor tables' but it also look like its a requirement for SHOW ENGINE INNODB STATUS command too.
How to repeat:
[root@dixon mysql51]# mysql -u root
Server version: 5.1.28-debug Source distribution
mysqlGRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER
- ON *.*
- TO 'mysqluser'@'localhost'
- IDENTIFIED BY 'agent_password';
Query OK, 0 rows affected (0.00 sec)
mysqlquit
Bye
[root@dixon mysql51]# mysql -u mysqluser -pagent_password
mysqlshow engine innodb status;
ERROR 1227 (42000): Access denied; you need the PROCESS privilege for this operation
mysqlquit
Bye
[root@dixon mysql51]# mysql -u root
mysqlGRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS ON *.* TO 'mysqluser'@'localhost' IDENTIFIED BY 'agent_password';
Query OK, 0 rows affected (0.00 sec)
mysqlquit
[root@dixon mysql51]# mysql -u mysqluser -pagent_password
mysqlshow engine innodb status;
.......(it worked)
Suggested fix:
Fix docs so that people using MEM on newer MySQL servers do not run into problems.
