mysql privilege on usage code example

Example: how to add privilege in mysql user

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';