Page 1 of 1
MySQL db access from pc ?
Posted: Wed Dec 10, 2003 1:38 am
by anjanesh
When a MySQL db is stored on the sever. How is possible for ONLY the php page on the server to access it ? If a person knows the db name, table name, fields etc then he might as well just connect to that db using his MySQL on his pc. Is that possible ?
Thanks
Posted: Wed Dec 10, 2003 4:16 am
by Weirdan
1. you can configure your mysql to not listen TCP socket so only local connection will be possible.
2. you can set your GRANTS to allow users only from specified host(s).
3. You can block mysql port using firewall.
2moderators:
please move this thread to Databases forum, it has nothing to do with PHP - Code