Search code examples
mysqlfederated-table

Show federated connections stored in MySQL database

I am feeling little bit stupid about this topic so I have to ask.

I am using Federated engine to be able to retrieve data from another database via CREATE SERVER instead of using CONNECTION

Works like a charm but... how can I retrieve the servers I created?

Thanks in advance

Solution

  • you can look in table servers at schema mysql like this:

    SELECT * FROM mysql.servers;