Create a new user account and designate the relevant permissions

Syntax:

CREATE USER '<user>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, SHOW DATABASES, SHOW VIEW ON *.* TO '<user>'@'%';
GRANT EXECUTE ON xp_readerrorlog TO <user>;

Substitute <new_user> and <password> with the newly username and password you have just created.

Example:If the newly created username is appuser and the password is appuserpass, use these details in place of <new_user> and <passwords>."

CREATE USER 'appuser'@'%' IDENTIFIED BY 'appuserpass';
GRANT SELECT, SHOW DATABASES, SHOW VIEW, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'appuser'@'%';
GRANT EXECUTE ON xp_readerrorlog TO 'appuser';