Bug #73345 MySQL need to have a restricted mode, allow root and replication slave only.
Submitted: 21 Jul 2014 15:11 Modified: 24 Oct 2014 7:31
Reporter: Fangxin Flou (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version:All OS:Any
Assigned to: CPU Architecture:Any
Tags: Connection, DBA, MySQL

[21 Jul 2014 15:11] Fangxin Flou 
Description:
In trouble shooting after MySQL restart, it's suggest to enter an restricted mode, which allow root user and replication slave connect through only.

for example, we introduce a variable "login_restirct_mode" with default value on, after check every thing, we could just turn it off to allow application connections.

set global login_restirct_mode off

Current solution is to change the port number and start it, we may forget it and not good enough.

Thanks.

How to repeat:
N/A

Suggested fix:
To be done.
[24 Oct 2014 7:31] Fangxin Flou 
MySQL 5.7.5 already have offline mode for this function.