6.3 MySQL User Account Management

[+/-]

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.