Federated table does not show the connection URL
Hi ,
I'm working with the federated tables and when i try to alter the connection string for connection to the remote server , the application seems does not provide the utility for making changes. Thanks
Example
---------
ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://username:pass@serverip:3306/dbname/tablename';
I'm working with the federated tables and when i try to alter the connection string for connection to the remote server , the application seems does not provide the utility for making changes. Thanks
Example
---------
ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://username:pass@serverip:3306/dbname/tablename';
I agree with the OP. We use federated tables also, and, connection info should be there. This should include "create server" type connections as well, which would mean supporting adding and changing those. The danger here is using the create statement as shown in that tab for some purpose and destroying the connection. +1 for this feature.
Please login to leave a reply, or register at first.