Essentials
...
SHOW VIEW
PROCESS (as of MySQL 8.x)
EVENT
TRIGGER
SHOW DATABASES
RELOAD
Flow User Sample
Create a user with all the necessary privileges to install and run Flow for Chameleon. SUPER privilege is not required assuming server is configured correctly (need log_bin_trust_function_creators=1 set when bin logging enabled.) The use of 127.0.0.1 instead of localhost below is used to enable connecting to a second instance of MySQL on a non-default port. If you use localhost the MySQL command line interface ignores any other port specification and always uses the default 3306 port.
...
| Code Block | ||
|---|---|---|
| ||
GRANT SYSTEM_USER ON *.* TO 'FLOW'@'localhost';
... run stored procedure scripts / DB Updates ...
REVOKE SYSTEM_USER ON *.* FROM 'FLOW'@'localhost'; |
...