Create user in MySQL with read only database right

Create user in MySQL with readonly right

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, SHOW VIEW ON  DBName.* TO 'username'@'localhost';

Post a Comment

Mới hơn Cũ hơn