In the mysql prompt:

CREATE DATABASE mydb;
CREATE USER user@localhost;
SET PASSWORD FOR user@localhost= PASSWORD("password");
GRANT ALL PRIVILEGES ON mydb.* TO user@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;