SET PASSWORD

Description

The SET PASSWORD statement is used to modify a user's login password.

Syntax

SET PASSWORD [FOR <user_identity>] =
    [PASSWORD(<plain_password>)]|[<hashed_password>]

Required Parameters

1. <plain_password>

The input is a plaintext password. Taking the password 123456 as an example, directly use the string 123456.

2. <hashed_password>

The input is an encrypted password. Taking the password 123456 as an example, directly use the string *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9, which is the return value of the function PASSWORD('123456').

Optional Parameters

1. <user_identity>

The user_identity here must exactly match the user_identity specified when creating a user with CREATE USER, otherwise an error will be reported that the user does not exist. If user_identity is not specified, the current user is 'username'@'ip', which may not match any user_identity. Current users can be viewed through SHOW GRANTS.

Access Control Requirements

The user executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
ADMIN_PRIV	USER or ROLE	User or Role has the ADMIN_PRIV privilege to modify all user's password, otherwise only the current user's password can be modified.

Usage Notes

Since 4.1.5, only 'root'@'%' is the special root identity. An identity such as 'root'@'localhost' remains an ordinary user and gains no privilege to modify the actual root account merely from its username. Protection of the actual root account also does not apply to other users named root.

• If the FOR user_identity field does not exist, then change the current user's password.

Example

• Modify the current user's password

SET PASSWORD = PASSWORD('123456')
SET PASSWORD = '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9'

• Modify the specified user password

SET PASSWORD FOR 'jack'@'192.%' = PASSWORD('123456')
SET PASSWORD FOR 'jack'@['domain'] = '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9'