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 …