# database link between mysql servers

**URL:** <https://forums.percona.com/t/database-link-between-mysql-servers/1473>\
**Category:** Other MySQL® Questions\
**Created:** [August 9, 2010, 6:06pm UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473 "2010-08-09T18:06:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gjuan](https://avatars.discourse-cdn.com/v4/letter/g/53a042/32.png) [@gjuan](https://forums.percona.com/u/gjuan)\
**Post date:** [August 9, 2010, 6:06pm UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473/1 "2010-08-09T18:06:35Z")

</div>

Hi,

I know that is not possible to create a database link between mysql servers. Is there some function or trick to solve the problem without using federated engine.?

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\
**Post date:** [August 10, 2010, 7:01am UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473/2 "2010-08-10T07:01:41Z")

</div>

No, federated engine is what you use to query tables on a remote server as if they where local, if that was what you where referring to.

---

<div class="post-metadata">

**Author:** ![gjuan](https://avatars.discourse-cdn.com/v4/letter/g/53a042/32.png) [@gjuan](https://forums.percona.com/u/gjuan)\
**Post date:** [August 12, 2010, 11:08am UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473/3 "2010-08-12T11:08:00Z")

</div>

Thanks for your answer.

---

<div class="post-metadata">

**Author:** ![johan](https://avatars.discourse-cdn.com/v4/letter/j/dec6dc/32.png) [@johan](https://forums.percona.com/u/johan)\
**Post date:** [December 24, 2010, 7:57pm UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473/4 "2010-12-24T19:57:44Z")

</div>

It is possible to link between MySQL server with MSSQL Server.  
Try read below link which is explain how to.  
[http://www.infi.nl/blog/view/id/4/How\_To\_MySQL\_as\_a\_linked\_s](http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_s) erver\_in\_MS\_SQL\_Server?ID=6&article=6

---

<div class="post-metadata">

**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\
**Post date:** [December 25, 2010, 11:01am UTC](https://forums.percona.com/t/database-link-between-mysql-servers/1473/5 "2010-12-25T11:01:42Z")

</div>

johan wrote on Sat, 25 December 2010 02:27

> [@](#):
>
> It is possible to link between MySQL server with MSSQL Server.  
> Try read below link which is explain how to.  
> [http://www.infi.nl/blog/view/id/4/How\_To\_MySQL\_as\_a\_linked\_s erver\_in\_MS\_SQL\_Server?ID=6&article=6](https://http)

Except that is not between two MySQL servers, that is between a MySQL server and a MSSQL server.  
And you can only get access to the MySQL databases in the MSSQL server and not the other way around.  
So even if you connect one MSSQL server to two MySQL servers you still would not have access to the other MySQL server from the first.