MySQL Databases

Some MySQL handy oneliners:

• List all users from running instance:

SELECT User, Host, Password FROM mysql.user;

• Create new user called newuser

CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';