Essentials

...

If dumping all databases at once

• SHOW DATABASES

If pulling master data from a server

• 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.

CREATE USER 'flow'@'127.0.0.1' IDENTIFIED  BY 'password'; -- WITH caching_sha2_password

GRANT
    ALTER,
    ALTER ROUTINE,
    CREATE,
    CREATE ROUTINE,
    CREATE TEMPORARY TABLES,
    CREATE VIEW,
    DELETE,
    DROP,
    EXECUTE,
    INDEX,
    INSERT,
    LOCK TABLES,
    REFERENCES,
    SELECT,
    SHOW VIEW,
    TRIGGER,
    UPDATE
ON superticker.*
TO 'flow'@'127.0.0.1';

GRANT SELECT ON `mysql`.*
TO `flow`@'127.0.0.1';

GRANT 
    CREATE USER, 
    RELOAD
ON *.* 
TO 'flow'@'127.0.0.1' WITH GRANT OPTION;

flush privileges;

...