From: <[EMAIL PROTECTED]> > > 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. >
I am also interested in this and I know that I need to create a MySQL user on the second database, but I don't know if it is possible to use a query like: select database1.users.address from database1, database2 where database1.users.username=database2.members.username; I kno this is possible if both databases are using the same database management system (on the same computer), but I don't know if it is possible to do it with 2 different systems. (But I think the client application will need to make 2 separate queries to each database.) Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
