Bug #73597 Access denied for SHOW BINARY LOGS
Submitted: 15 Aug 2014 9:17 Modified: 7 Nov 2014 16:36
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:3.0.13, 3.0.14 OS:Any
Assigned to: CPU Architecture:Any

[15 Aug 2014 9:17] Daniël van Eeden 
Description:
In the agent log with 3.0.13 against a server running 5.1.59.
The agent has a general and a limited user, maybe it's using the wrong user?

2014-08-15 11:09:00,838  WARN com.mysql.etools.agent.collection.MysqlConnection: JDBC operation against 127.0.0.1:3306 failed due to StatementCallback; bad SQL grammar [SHOW BINARY LOGS]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need the SUPER privilege for this operation. Will not retry (operation was not retry-able or no retries are left)

How to repeat:
See agent log.
[7 Nov 2014 8:25] Daniël van Eeden 
Also happens with 3.0.14 and 5.1.49
[7 Nov 2014 16:35] MySQL Verification Team 
Verified. Needs SUPER privilege 5.1.63 and prior (see the manual). Workaround upgrade to 5.1.65.