Access denied; you need (at least one of) the SUPER privilege(s) for this operation

[Eduardo Legatti]

Hello All,

I’m trying to monitoring a MySQL RDS Instance on AWS using the MySQL Enterprise Monitor 3.0.15, but the the message below shows after finishing the configuration.

"Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

I'm using the "root" user. I noticed that AWS RDS instance don't permit that we grant the "SUPER" privilege to anyone.

Below are my connection settings.

Connect Using: TCP/IP
Instance Address: xxxx.rds.amazonaws.com
Port: 3306
Admin User: root
Admin Password: ********
Auto-Create Less Privileged Users: No
General User: I let this field blank
General Password: I let this field blank
Limited User: I let this field blank
Limited Password: I let this field blank

In fact, I followed the steps provided by the page below:

http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-install-agent-cloud.html

* Do not configure MySQL Enterprise Monitor to auto-create the less privileged Limited and General accounts, and instead use the Admin account for all monitoring.

* This is set in the Connection Settings tab when adding (or editing) a MySQL instance to be monitored. This Auto-Create Less Privileged Users setting defaults to Yes, so toggle it to No.

* Also under Connection Settings is the Instance Address parameter. Set this to your endpoint, which is the entry point for your MySQL Server web service.

* Change the inventory table schema for MySQL Enterprise Monitor Agent from "mysql" to an alternative (and existing) schema.


What am i doing wrong?

Thanks for your support ;-)

Legatti