MySQL Forums
Forum List  »  InnoDB

Re: 8.0.14 breaks mysqlpump
Posted by: Warren Prince
Date: January 26, 2019 07:49AM

No luck. Created a user 'tester'.
Show grants:

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `tester`@`%` WITH GRANT OPTION |
| GRANT APPLICATION_PASSWORD_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SYSTEM_VARIABLES_ADMIN,XA_RECOVER_ADMIN ON *.* TO `tester`@`%`

If it matters, for testing, I reduced the command to:

mysqlpump -u tester -p --log-error-file=/var/log/mysql/pump_error.log --skip-definer --set-gtid-purged=ON --result-file=intranet_beta.sql intranet_beta

Options: ReplyQuote


Subject
Views
Written By
Posted
875
January 24, 2019 11:33AM
510
January 25, 2019 04:22PM
534
January 25, 2019 05:40PM
504
January 26, 2019 02:54AM
Re: 8.0.14 breaks mysqlpump
510
January 26, 2019 07:49AM
484
January 26, 2019 06:41PM
427
January 26, 2019 08:02PM
464
January 26, 2019 08:41PM
379
January 27, 2019 06:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.