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?
limit mysql access?
Moderator: General Moderators
limit mysql access?
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.
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
hopefully the syntax is correct...........
Code: Select all
grant select
on
*.*
to
somename@locahost
identified by
'somepassword'