MySQL db access from pc ?

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
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

MySQL db access from pc ?

Post 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
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post 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
Post Reply