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
927
January 24, 2019 11:33AM
536
January 25, 2019 04:22PM
551
January 25, 2019 05:40PM
523
January 26, 2019 02:54AM
Re: 8.0.14 breaks mysqlpump
530
January 26, 2019 07:49AM
507
January 26, 2019 06:41PM
450
January 26, 2019 08:02PM
488
January 26, 2019 08:41PM
395
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.