Industrial Connectivity - Basic Setup of MySQL Server and Create MySQL Export Gateway

Подробнее о видео

This 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;