"Peter Lauri" <[EMAIL PROTECTED]> wrote on 11/25/2005 04:43:50 AM:

> Hi,
> 
> I have two databases. Database A is located on a server that I run my 
web
> hosting from. The other database B is located on a computer with a fixed 
IP.
> How can I configure database B so I can access database B from my web
> server? From my A system I would like to be able to do INSERT, SELECT 
and
> UPDATE queries on the database B.
> 
> Best regards,
> 
> Peter Lauri
> 

All you need is do is to setup a MySQL user (not a system user) account on 
B that your application on A can use. Use the GRANT statement to do this.

http://www.uic.edu/classes/bms/bms655/lesson9.html 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Reply via email to