[talk] Databases

[N.J. Thomas]

* Sujit K M <kmsujit at gmail.com> [2016-10-17 21:10:43+0530]:
> > If I understood you correctly, I think what you want is to create a
> > user and grant them only read permissions. Here's the syntax for the
> > GRANT command:
>
> I was more interested in making the mysql server itself readonly.

[...]

> "If we make an Database read only then we need to return 0 in the case of
> Insert/Update statements", 0 being the number of records which are inserted.

Okay. Can I ask why you want this? What are you trying to accomplish by
doing this?

Giving a user readonly access to a table/database is a fairly common
thing. What you are trying to do is less common, and AFAICT, from the
MYSQL docs, not really recommended.

Thomas