Create new MySQL user account

The command below will create MySQL user called 'testuser' on localhost with all privileges
for database called 'testdb' and with password 'mypassword'. Connect to the server with mysql
and run command:

grant all on testdb.* to testuser@localhost identified by 'mypassword';