Not the answer you need?
Register and ask your own question!

Access denied you need at least SUPER priviledge

ddillmanddillman EntrantCurrent User Role Beginner
I am getting this error:


error configuring MySQL: Error 1227: Access denied; you need (at least one of) the SUPER privilege(s) for this operation warning

I have slow query turned on in Aurora. Why am I getting this message in QAN? I have the collect from set to slow log also. I think this was answered somewhere else, but couldn't find it.


Comments

  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi ddillman

    With Aurora your only option for Query Analytics (QAN) is to enable PERFORMANCE_SCHEMA and obtain query results from there, as the slow log is not an option with Aurora. Please change the setting to get the queries from P_S and let us know if the error continues to occur. Thanks,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.