Page 1 of 1

limit mysql access?

Posted: Fri Feb 24, 2006 12:04 pm
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?

Posted: Fri Feb 24, 2006 12:06 pm
by josh
Yes, make a user with read permissions

look for the GRANT syntax in the manual

Posted: Fri Feb 24, 2006 1:09 pm
by raghavan20
hopefully the syntax is correct...........

Code: Select all

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