|
|
Posted by emre on 11/10/62 11:12
mysql comes with 2 predefined databases, their names are
> show databases;
1. mysql
2. 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
>
>
Navigation:
[Reply to this message]
|