$mysql -u root -p

Log in to MySQL, enter password.

select user from mysql.user;

List existing users.

create user 'username'@'localhost' identified by 'user_password';

Create user, setting their password. User is restricted to log in from the local machine.

create database database_name;

Create the database.

grant all privileges on database_name.* to 'username'@'localhost';

Grant rights to the user for the database.