Here is a quick tip how to create from mysql cli a new database and a new mysql user that has full privileges on this newly created database:
1 2 3 4
For a new mysql user with full privileges on all mysql databases you would use:
These users are accessible only from localhost, and for ex. if you want the user to be accessible from any host (not a good idea) you just have to use % instead of localhost, like:
These are just simple, but frequently used forms of the mysql commands used to create new mysql users, but they can be used for more complex things: check the mysql manual page for full details.