"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