create new user other than root in mysql code example

Example: how to create new database user

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