Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
MySQL Database Read-Only MySQL Database Read-Only
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 05-16-2010, 12:38 PM   #1
Cyber Fucker
Hmm
 
Cyber Fucker's Avatar
 
Industry Role:
Join Date: Sep 2005
Location: On an endless road around the world for rock and roll.
Posts: 12,642
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.
__________________
Cyber Fucker is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-16-2010, 12:42 PM   #2
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
Old 05-16-2010, 12:54 PM   #3
Cyandin
Confirmed User
 
Industry Role:
Join Date: Aug 2008
Posts: 1,723
Quote:
Originally Posted by Varius View Post
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>
Cyandin is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-16-2010, 01:55 PM   #4
LoveSandra
So Fucking Banned
 
Join Date: Aug 2008
Location: Just Blow Me
Posts: 10,551
bump bump
LoveSandra is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-16-2010, 02:55 PM   #5
Cyber Fucker
Hmm
 
Cyber Fucker's Avatar
 
Industry Role:
Join Date: Sep 2005
Location: On an endless road around the world for rock and roll.
Posts: 12,642
Quote:
Originally Posted by Varius View Post
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!
__________________
Cyber Fucker is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-16-2010, 03:03 PM   #6
Davy
Confirmed User
 
Davy's Avatar
 
Industry Role:
Join Date: Apr 2006
Location: Germany
Posts: 4,323
:2cents
Quote:
Originally Posted by Varius View Post
GRANT only the SELECT privilege...
Quote:
Originally Posted by Cyandin View Post
</thread>
Quote:
Originally Posted by LoveSandra View Post
bump bump
Fail!
__________________
---
ICQ 14-76-98 <-- I don't use this at all
Davy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-16-2010, 03:08 PM   #7
woj
<&(©¿©)&>
 
woj's Avatar
 
Industry Role:
Join Date: Jul 2002
Location: Chicago
Posts: 47,882
Quote:
Originally Posted by Varius View Post
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.
__________________
Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager
woj is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
MySQL Database Read-Only MySQL Database Read-Only
« Previous Thread | Next Thread »

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.