Add ability to have a MySQL user who has system access to do administrative tasks but limited access to user schema
Add three new options to allow specification of utility user:
* utility_
* utility_
* utility_
This user has a mixed and special scope of abilities and protection:
* Utility user must not be seen or modified by any other user, including root.
* Utility user must not have the ability create, modify, delete or see any schemas not specified.
* Utility user may modify system variables.
* Utility user may modify other system users, primarily for the purpose of password reset/recovery.
When the server starts, it will note in the log output that the utility user exists and the schemas that it has access to.
See internal #23597.
Blueprint information
- Status:
- Complete
- Approver:
- Alexey Kopytov
- Priority:
- Undefined
- Drafter:
- George Ormond Lorch III
- Direction:
- Approved
- Assignee:
- George Ormond Lorch III
- Definition:
- Approved
- Series goal:
- Proposed for 5.5
- Implementation:
- Implemented
- Milestone target:
- 5.5.27-28.0
- Started by
- Alexey Kopytov
- Completed by
- Alexey Kopytov