Bug #64294 deny connection from common user
Submitted: 10 Feb 2012 16:34 Modified: 16 Feb 2012 12:42
Reporter: xiaobin lin (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution, deny connection

[10 Feb 2012 16:34] xiaobin lin 
Description:
  There maybe suh requirement, after MySQL just start, the DBA will do some operation on the data, but he do not want other uses (or applications) to connect the the server.
  If there is a variable to control whether normal user (do not have SUPER_ACL priv) can connect. This can be fullfiled.

How to repeat:
read the code

Suggested fix:
A new variable to control the switch, says deny_new_conn, defaul off. If on, only users that have the SUPER_ACL priv can connect successfully.

The connections that are established before "set gloal deny_new_conn=on" will not be affected.

Patch file is attached.
[10 Feb 2012 16:42] xiaobin lin 
It is based on 5.5.22. bzr  revno: 3694

Attachment: deny_new_connection.patch (application/octet-stream, text), 2.28 KiB.
[16 Feb 2012 12:42] Valeriy Kravchuk 
Thank you for the feature request and patch contributed.