Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement