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
1066
January 24, 2019 11:33AM
594
January 25, 2019 04:22PM
612
January 25, 2019 05:40PM
581
January 26, 2019 02:54AM
Re: 8.0.14 breaks mysqlpump
610
January 26, 2019 07:49AM
567
January 26, 2019 06:41PM
525
January 26, 2019 08:02PM
550
January 26, 2019 08:41PM
471
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.