Show all users
select User, Host, Password from mysql.user;Create User
CREATE USER 'ross'@'localhost' IDENTIFIED BY '**************'; Change User Password
ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';Drop User
DROP USER 'ross'@'localhost';Grant all db privileges to user
GRANT ALL ON test1.* to 'ross'@'%';Show grants
SHOW GRANTS FOR ross;