MySql : Grant read only options?

Question

I have a user, whom I want to grant all the READ permission on a db schema.

One way is this :

GRANT SELECT, SHOW_VIEW  ON test.* TO 'readuser'@'%';

Is there a way to group all read operations in grant ?

Answer 1

Try using the code given below:

GRANT SELECT ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password';

And, this will create a user with SELECT privilege for all database including Views.