limit mysql access?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

limit mysql access?

Post by s.dot »

I have apache/php/mysql running on my computer. I have my websites documents on my computer. I configured my server to allow me to connect to the database that I'm using for the live website. However, I only want to be able to read from it, as I don't want to accidentally write something during testing scripts.

Is this possible?
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Post by josh »

Yes, make a user with read permissions

look for the GRANT syntax in the manual
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

hopefully the syntax is correct...........

Code: Select all

grant select
on
*.*
to
somename@locahost
identified by
'somepassword'
Post Reply