Syntax:
CREATE USER '<user>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, SHOW DATABASES, SHOW VIEW ON *.* 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'@'%';
Comments
0 comments
Article is closed for comments.