title: How do I create a MySQL View that reads its data from a different server and database?
body: <p>I have a table test1, which is stored in MySQL database dbtest, on host server_A. I want to create a view V on database MySQL test2, on host server_B. I want to read data from table test2 into view V. and...I'm not allowed to use replication. Can MySQL even read data from another MySQL sever? is it possible?</p>