Bug #79774 super_read_only as a server option does not also set read_only

• Submitted: 25 Dec 2015 8:42
• Modified: 29 Dec 2015 11:30
• Reporter: Zhenye Xie (OCA)
• Status: Verified
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.7.10, 5.7.11
• OS: Any
• CPU Architecture: Any

[25 Dec 2015 8:42] Zhenye Xie

Description:
super_read_only as a server option does not also set read_only

maybe it associates with http://bugs.mysql.com/bug.php?id=79328

How to repeat:
start mysqld with --super-read-only

mysql> show variables like '%read_only%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| innodb_read_only | OFF   |
| read_only        | OFF   |
| super_read_only  | ON    |
| tx_read_only     | OFF   |
+------------------+-------+
4 rows in set (0.00 sec)

[29 Dec 2015 11:30] MySQL Verification Team

Hello Zhenye,

Thank you for the report.
Observed this with 5.7.10, 5.7.11.

Thanks,
Umesh