Bug #110697 Make super_read_only a SESSION variable
Submitted: 14 Apr 2023 13:34 Modified: 17 Apr 2023 3:33
Reporter: IGG t Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Apr 2023 13:34] IGG t 
Description:
Super_read_only is great as it stops any accidental changes to the database, but sometimes it is required to remove it to make small changes. 
However, as it is a global variable you have to remove super_read_only for everyone. 

e.g. if you need to run a command that takes 2 minutes to run, that is 2 minutes in which time someone else could connect and modify the database.

It would be really useful it this could be done on a per session basis so that only the person who needs access is given read/write access and everyone else remains read_only.

How to repeat:
SET @@session.super_read_only=0;

Suggested fix:
make super_read_only available at the session level.
[17 Apr 2023 3:33] MySQL Verification Team 
Hello IGG t,

Thank you for the feature request!

regards,
Umesh