FORclause, this statement sets the password for the current user:
SET PASSWORD =
Any client who connects to the server using a nonanonymous account can change the password for that account. To see which account the server authenticated you as, invoke the
old_passwordsvalues are described later in this section.
FORclause, this statement sets the password for the named account, which must exist:
SET PASSWORD FOR 'jeffrey'@'localhost' =
In this case, you must have the
UPDATEprivilege for the
read_only system variable is enabled,
SET PASSWORD requires the
SUPER privilege in addition to any other required privileges.
FOR clause is given, the account name uses the format described in Section 6.2.3, “Specifying Account Names”. The
user value should be given as
' are exactly as listed in the
Host columns of the account's
mysql.user table row. If you specify only a user name, a host name of
'%' is used. For example, to set the password for an account with
Host column values of
'%.example.org', write the statement like this:
SET PASSWORD FOR 'bob'@'%.example.org' = PASSWORD('