Help Center/ Relational Database Service/ User Guide (Ally Region)/ Troubleshooting/ RDS for MySQL/ Parameter-related Issues/ Global Parameters Fail to Change
Updated on 2025-12-26 GMT+08:00
Global Parameters Fail to Change
Scenario
A global parameter failed to be changed for an RDS for MySQL instance.
MySQL [(none)]> show variables like 'binlog_expire_logs_seconds'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | binlog_expire_logs_seconds | 3600 | +----------------------------+-------+ 1 row in set (0.00 sec) MySQL [(none)]> set global binlog_expire_logs_seconds=600; ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation MySQL [(none)]>
Solution
Change global parameters on the RDS console because RDS for MySQL does not support global parameter changes using commands.
Parent topic: Parameter-related Issues
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot