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';

Share on Google Plus

About Md. Shahzad Alam

I am a passionate cloud and DevOps professional specializing in Linux and open-source solutions. Through this blog, I share my knowledge and experience with the community, offering tips and insights on cloud technologies and DevOps practices.