get users assigned to database mysql code example

Example: how to add privilege in mysql user

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