database link between two mysql servers running in two different locations

Please tell me how to开发者_开发技巧 connect to mysql database server from another mysql database server running in two different locations and access all the tables and update them ?

---

afaik there is no direct "database link" in mysql like there is in oracle. what you can do is master-master replication of two databases and then update locally. similar question with more info:

Oracle Database Link - MySQL Equivalent?

---

You could pop a MySQL Proxy client between the two servers and send your queries to it and let it do all the talking backwards and forwards between the other boxes.