Log in:
mysql -u root -p
Create a user:
create user 'newuser'@'localhost' IDENTIFIED BY 'password';
Give them all the power:
grant all privileges on * . * TO 'newuser'@'localhost';
Reload privileges:
flush privileges;
Ditch a user: (Optional)
drop user 'newuser'@'localhost';
Log out:
\q
—————-
Log in:
mysql -u newuser -p
Create a database for the user:
create database db_name;
List databases: (Optional)
show databases;
Ditch database: (Optional)
drop database db_name;
Log out:
\q
Done.