federated_coa.sql

-- On DM server
create server 'coa_federated' foreign data wrapper 'mysql' options (HOST '127.0.0.1', DATABASE 'coa_federated', USER 'root', PASSWORD 'changeme', PORT 3306, SOCKET '', OWNER 'root');

sudo cp /var/www/inducks/createtables_clean.sql /var/www/inducks/createtables_clean_federated.sql
sudo sed -i "s/MyISAM/FEDERATED CONNECTION=\"coa\"/g" /var/www/inducks/createtables_clean_federated.sql

-- On coa server
CREATE USER federated@'%' IDENTIFIED BY 'changeme';
GRANT ALL ON coa.* TO federated@'%';
FLUSH PRIVILEGES;