Industrial Connectivity - Basic Setup of MySQL Server and Create MySQL Export Gateway
Channel:
Subscribers:
352,000
Published on ● Video Link: https://www.youtube.com/watch?v=_suVAhGMYL0
6This video explains how to set up a MySQL server being able to receive data and how to configure the BFC Gateway as a MySQL Client to send the data via an Export Gateway.
Prompt:
1.CREATE DATABASE bfcdatabase;
2.CREATE USER 'bfc4mysql'@'192.168.178.123' IDENTIFIED BY 'dbpassword';
3.GRANT ALL PRIVILEGES ON bfcdatabase.* TO 'bfc4mysql'@'192.168.178.123';
4.UPDATE db SET Host='192.168.178.123' where Db='bfcdatabase';
5.UPDATE user SET Host='192.168.178.123' where user='bfc4mysql';
6.FLUSH PRIVILEGES;