create a readonly connection to MySQL?

Question

I looked at the MySql Connection Options and it doesnt seem to be there. Is there a way to create a read only connection/command for .NET? With SQLite i could specify read only=true to do this. What can i do with MySQL?

Answer 1

You can create a user with SELECT only privileges

Answer 2

You need to add SELECT privileges to a user using GRANT eg:

GRANT SELECT ON db_base.* TO db_user@'localhost' IDENTIFIED BY 'db_passwd';

Resources:

The MySQL Access Privilege System
MySQL grant