check what account have specific privilege+mysql code example

Example: how to add privilege in mysql user

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