Search code examples
mysqlfederated

Where is connection string of federated table stored in mysql?

I have many federated tables in my mysql database. I can see the connection string when I open the table structure in dbforge. But i am not able to find where it is stored in mysql.

I checked Information_schema tables and only found the table structures without the connection string

Solution

  • Its either in the table defination (SHOW CREATE TABLE {tablename}), or the mysql.servers table (SHOW SERVERS).

    ref: how to create federated tables