Re: can I limit DB access
| From: | emre at vt dot com dot tr | Date: | Fri, 01 Apr 2005 22:12:42 +0000 |
| Subject: | Re: can I limit DB access | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-212061@lists.php.net to get a copy of this message | ||
mysql comes with 2 predefined databases, their names are
show databases; 1. mysql2. test open mysql database
use mysql;find the table named as 'user' , there mysql users and their access privileges are stored.
select Host, User, Password from user modify Host column as you wish to limit access to your database. also you'd better check other columns to understand how to grant priviliges to mysql users.btw dont forget to flush privileges after you are done with the modification.
flush privileges;hope this helps. ----- Original Message ----- From: "Dave Reinhardt" <Dave@SeaPortNet.com> To: "PHP General-List" <php-general@lists.php.net> Sent: Friday, April 01, 2005 11:22 PM Subject: [PHP] can I limit DB access
How can I limit access to my database to one computer or one domain? I do not want it accessable from just any place on the web. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php