GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   MySQL Database Read-Only (https://gfy.com/showthread.php?t=968680)

Cyber Fucker 05-16-2010 12:38 PM

MySQL Database Read-Only
 
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. :helpme

Varius 05-16-2010 12:42 PM

Quote:

Originally Posted by Cyber Fucker (Post 17145464)
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. :helpme

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 05-16-2010 12:54 PM

Quote:

Originally Posted by Varius (Post 17145471)
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 05-16-2010 01:55 PM

bump bump

Cyber Fucker 05-16-2010 02:55 PM

Quote:

Originally Posted by Varius (Post 17145471)
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! :thumbsup

Davy 05-16-2010 03:03 PM

Quote:

Originally Posted by Varius (Post 17145471)
GRANT only the SELECT privilege...

Quote:

Originally Posted by Cyandin (Post 17145498)
</thread>

Quote:

Originally Posted by LoveSandra (Post 17145676)
bump bump

Fail! :1orglaugh

woj 05-16-2010 03:08 PM

Quote:

Originally Posted by Varius (Post 17145471)
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.

:thumbsup


All times are GMT -7. The time now is 03:54 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc