Articles in this section

See more

Create a new user and provide permissions.

Arcturus Support
  • Updated
Follow

Syntax: 

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

Replace <new_user> and <password> with the newly created username and password.

Example:Let's considernewly createdusername isappuserand password isappuserpass

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

Related articles

Comments

0 comments

Article is closed for comments.