Create a User¶
CREATE USER '${USERNAME}'@'${HOSTNAME}' IDENTIFIED BY '${PASSWORD}';
You can use %
as the host to act as a wildcard.
Alter a User¶
ALTER USER '${USERNAME}'@'${HOSTNAME}' IDENTIFIED BY '${PASSWORD}';
Root¶
Root is identified by root@localhost
:
ALTER USER 'root'@'localhost' IDENTIFIED BY '${NEW_PASS}';
List Users¶
SELECT `User`,`Host` FROM `mysql`.`user`;
Delete a User¶
DROP USER '${USERNAME}'@'${HOSTNAME}';