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
177
January 24, 2019 11:33AM
92
January 25, 2019 04:22PM
97
January 25, 2019 05:40PM
89
January 26, 2019 02:54AM
Re: 8.0.14 breaks mysqlpump
101
January 26, 2019 07:49AM
107
January 26, 2019 06:41PM
88
January 26, 2019 08:02PM
91
January 27, 2019 06:41AM


Sorry, only registered users may post in this forum.

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.