MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
[+/-]
- 6.3.1 User Names and Passwords
- 6.3.2 Adding User Accounts
- 6.3.3 Removing User Accounts
- 6.3.4 Using Roles
- 6.3.5 Reserved User Accounts
- 6.3.6 Setting Account Resource Limits
- 6.3.7 Assigning Account Passwords
- 6.3.8 Password Management
- 6.3.9 Server Handling of Expired Passwords
- 6.3.10 Pluggable Authentication
- 6.3.11 Proxy Users
- 6.3.12 User Account Locking
- 6.3.13 SQL-Based MySQL Account Activity Auditing
This section describes how to set up accounts for clients of your MySQL server. It discusses the following topics:
The meaning of account names and passwords as used in MySQL and how that compares to names and passwords used by your operating system
How to set up new accounts and remove existing accounts
How to use roles, which are named collections of privileges
How to change passwords
Guidelines for using passwords securely
See also Section 13.7.1, “Account Management Statements”, which describes the syntax and use for all user-management SQL statements.