Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I think the closest thing to what the post body is suggesting is offline mode: Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate...
Answer
#2: Post edited
by
Alexei
·
2020-09-01T05:19:11Z (over 4 years ago)
I think the closest thing to what you are looking for is called [offline mode](https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_offline_mode):- > * Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate error. Disconnection includes terminating running statements and releasing locks. Such clients also cannot initiate new connections, and receive an appropriate error.
- > * Connected client users who have the SUPER privilege are not disconnected, and can initiate new connections to manage the server.
- > To put a server in offline mode, change the value of the offline_mode system variable from OFF to ON. To resume normal operations, change offline_mode from ON to OFF.
- I think the closest thing to what the post body is suggesting is [offline mode](https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_offline_mode):
- > * Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate error. Disconnection includes terminating running statements and releasing locks. Such clients also cannot initiate new connections, and receive an appropriate error.
- > * Connected client users who have the SUPER privilege are not disconnected, and can initiate new connections to manage the server.
- > To put a server in offline mode, change the value of the offline_mode system variable from OFF to ON. To resume normal operations, change offline_mode from ON to OFF.
#1: Initial revision
by
Alexei
·
2020-09-01T05:15:58Z (over 4 years ago)
I think the closest thing to what you are looking for is called [offline mode](https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_offline_mode): > * Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate error. Disconnection includes terminating running statements and releasing locks. Such clients also cannot initiate new connections, and receive an appropriate error. > * Connected client users who have the SUPER privilege are not disconnected, and can initiate new connections to manage the server. > To put a server in offline mode, change the value of the offline_mode system variable from OFF to ON. To resume normal operations, change offline_mode from ON to OFF.