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

score 9 · Accepted Answer · edited Mar 19 '18 at 12:19

9

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

SELECT * FROM mysql.servers;

edited Mar 19 '18 at 12:19

avisheks

answered Feb 14 '17 at 12:29

Bernd Buffen

whoa. As I expected, just a simple query. Thanks! – Dan Delay Feb 14 '17 at 12:47
With this you can see a stored login and password for FEDERATED connection. – user2285323 Jan 26 '21 at 10:16

1 Answers1