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
949
January 24, 2019 11:33AM
548
January 25, 2019 04:22PM
562
January 25, 2019 05:40PM
534
January 26, 2019 02:54AM
Re: 8.0.14 breaks mysqlpump
553
January 26, 2019 07:49AM
518
January 26, 2019 06:41PM
466
January 26, 2019 08:02PM
500
January 26, 2019 08:41PM
406
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.