How to rename MySQL's Federated Engine SERVER name

Asked Aug 01 '19 at 14:22

Active Aug 01 '19 at 14:22

Viewed 231 times

i'm trying to change a SERVER variable's server name used in the CONNECTION definition of a Federated Table's table properties. i manually changed it (the Server_name column) on the mysql.servers table. However, when creating a new federated table with the renamed SERVER name, an error is displayed with below message:

1432 - server name: SERVER_NAME_HERE doesn't exist!

asked Aug 01 '19 at 14:22

Nii

After the manual change, did you restart MySQL?. – wchiquito Aug 01 '19 at 19:38
i didn't. am i required to? that's not really ideal specially on production servers – Nii Aug 02 '19 at 07:42
Was the change directly on the production server?. No test on a non-production server?. – wchiquito Aug 02 '19 at 17:13
I don't see the option in [13.1.8 ALTER SERVER Syntax](https://dev.mysql.com/doc/refman/8.0/en/alter-server.html) to modify `server_name`. – wchiquito Aug 02 '19 at 19:17

How to rename MySQL's Federated Engine SERVER name

0 Answers0