Bug #78385 Getting error when trying to "Install Helper" for performance schema (RDS 5.6)

• Submitted: 9 Sep 2015 22:24
• Modified: 9 Oct 2015 23:43
• Reporter: Mihail Manolov
• Status: No Feedback
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 6.3.4
• OS: MacOS
• CPU Architecture: Any
• Tags: performance_schema sys

[9 Sep 2015 22:24] Mihail Manolov

Description:
When I attempt to use Performance tab for RDS instance, and click on PERFORMANCE -> Performance Reports -> Install Helper, I get the following message:

ERROR 1227 (42000) at line 8 in file: './before_setup.sql': Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How to repeat:
Create RDS instance with engine MySQL 5.6.
Connect to it with MySQL Workbench.
Click on PERFORMANCE -> Performance Reports -> Install Helper

Suggested fix:
"SET sql_log_bin = 0;" is not allowed in RDS instance.

[9 Sep 2015 23:35] Mihail Manolov

Workaround (requires Terminal, MySQL client and Perl):

cd /Applications/MySQLWorkbench.app/Contents/Resources/sys

vi before_setup.sql
# Disable SET sql_bin_log = 0
 
find . -name "*.sql" | xargs perl -pi -e "s/'root'\@'localhost'/CURRENT_USER/g"
 
mysql -u dba -psecret -h xxx.xxx.us-east-1.rds.amazonaws.com < sys_56.sql

[9 Sep 2015 23:43] MySQL Verification Team

Looks related to this bug: https://bugs.mysql.com/bug.php?id=74839.

[10 Oct 2015 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".