Skip to content

Instantly share code, notes, and snippets.

@bperel

bperel/federated_coa.sql

Created September 30, 2016 08:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bperel/a1a30d0a5e30a8671a419579d81a17af to your computer and use it in GitHub Desktop.
Save bperel/a1a30d0a5e30a8671a419579d81a17af to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment