# 命令行修改MySQL global参数失败
#### 场景描述
修改MySQL global参数失败：
```
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)]>
```
#### 解决方案
RDS for MySQL不支持在数据库中执行修改全局参数的命令，您可以到控制台修改参数。详见[是否支持使用SQL命令修改全局参数](https://support.huaweicloud.com/rds-mysql_faq/rds_faq_0175.html)。