MySQL Database Read-Only

[Cyber Fucker]

Is there is an easy and quick way to make MySQL database unwritable (possibly in phpmyadmin) ?

So when I am going to edit it I make it writable for a while and then after this I make it read-only for a better security.

[Varius]

Is there is an easy and quick way to make MySQL database unwritable (possibly in phpmyadmin) ?

So when I am going to edit it I make it writable for a while and then after this I make it read-only for a better security.

GRANT only the SELECT privilege to the user when you want it to be read-only. When you need to modify data, then use a different user with more privileges, or temporarily grant UPDATE/INSERT/DELETE whatever to your user, do you thing, and remove those once again.

[Cyandin]

GRANT only the SELECT privilege to the user when you want it to be read-only. When you need to modify data, then use a different user with more privileges, or temporarily grant UPDATE/INSERT/DELETE whatever to your user, do you thing, and remove those once again.

</thread>

[LoveSandra]

bump bump

[Cyber Fucker]

GRANT only the SELECT privilege to the user when you want it to be read-only. When you need to modify data, then use a different user with more privileges, or temporarily grant UPDATE/INSERT/DELETE whatever to your user, do you thing, and remove those once again.

Ok. I will try this! Thanks!

[Davy]

GRANT only the SELECT privilege...

</thread>

bump bump

Fail!

[woj]

GRANT only the SELECT privilege to the user when you want it to be read-only. When you need to modify data, then use a different user with more privileges, or temporarily grant UPDATE/INSERT/DELETE whatever to your user, do you thing, and remove those once again.