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';
Comments
0 comments
Article is closed for comments.