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.)
| Code Block | ||
|---|---|---|
| ||
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; |
Suspending Privileges
You may want to temporarily disable the access to the database. In that case you would use a REVOKE command:
...