Show federated connections stored in MySQL database

Question

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

Answer 1

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

SELECT * FROM mysql.servers;