User accounts can be created by using MySQL's GRANT statement. For this, you'll need to log in to MySQL using the root account, which has full privilege on the mysql.user table.
The following statement will create a user account named myusername which will have full access to the mydatabase database from localhost and set the password to mypassword
GRANT ALL ON mydatabase.* TO 'myusername'@'localhost' IDENTIFIED BY 'mypassword';
Comment anonymously. Login not required.