mysql - How to access a database in a different server? -


Today I have 2 databases (DB_A and DBB) in the same server (SERVER_1) when I switch between tables Need access to the tables - for example, I just need to reference the desired table:

  - Enter the code DB_B in DB_A ... DBB ... from TableInB ... ...  

But if I take DB_B from SERVER_1 to SERVER_2 then the above code will fail.

In MS-SQL, we can use a linked server, and just use SERVER_2.DB_B.Schema.TableInB , but something in MySQL Can not get the same.

It shows that ChrisForce is correct:, although limited, the way to link different servers is.


Comments