SET PASSWORD
Syntax
SET PASSWORD [FOR user] = { PASSWORD('some password') | OLD_PASSWORD('some password') | 'encrypted password' }
Contents
Description
The SET PASSWORD
statement assigns a password to an existing MariaDB user
account.
If the password is specified using the PASSWORD()
or OLD_PASSWORD()
function, the literal text of the password should be given. If the
password is specified without using either function, the password
should be the already-encrypted password value as returned by
PASSWORD()
.
OLD_PASSWORD()
should only be used if your MariaDB/MySQL clients are very old (< 4.0.0).
With no FOR
clause, this statement sets the password for the current
user. Any client that has connected to the server using a non-anonymous
account can change the password for that account.
With a FOR
clause, this statement sets the password for a specific
account on the current server host. Only clients that have the UPDATE
privilege for the mysql
database can do this. The user value should be
given in user_name@host_name
format, where user_name
and host_name
are
exactly as they are listed in the User and Host columns of the
mysql.user
table entry.
The PASSWORD()
function returns a 41 string hash.
The argument to PASSWORD()
and the password given to MariaDB clients can be of arbitrary length.
Example
For example, if you had an entry with User and
Host column values of 'bob
' and
'%.loc.gov
', you would write the
statement like this:
SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass');
See also
simple_password_check plugin
- permits the setting of basic criteria for passwordsALTER USER