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@xxxxxxxxxxxxxx>
To: "PHP General-List" <php-general@xxxxxxxxxxxxx>
Sent: Friday, April 01, 2005 11:22 PM
Subject: 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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
