How to create user

This command will create a user in mysql with full access to the selected database:
mysql> GRANT all ON DATABASE.* TO USER@localhost IDENTIFIED BY 'PASS';
mysql> FLUSH PRIVILEGES;

DATABASE: The database where the user will have full access.

USER: The username that will have full access to the database. It will be created.

PASS: The password for this user.