Complimenting the expanded CREATE USER
syntax introduced in
MySQL Server 5.7.6 is more useful ALTER USER
syntax.
Before MySQL Server 5.7.6, ALTER USER
could only be
used to expire a user’s password. That’s pretty limited.
With changes made in MySQL Server 5.7.6, a better
distinction is made between privilege-level attributes (those
which are managed via GRANT
and REVOKE
statements) and account-level attributes (those managed using
CREATE USER
and ALTER USER
statements).…
Oct
07
2015