View Single Post
Old 05-16-2010, 12:42 PM  
Varius
Confirmed User
 
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
Quote:
Originally Posted by Cyber Fucker View Post
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.
__________________
Skype variuscr - Email varius AT gmail
Varius is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote