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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.7.10, 5.7.11 OS:Any
Assigned to: 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