Failed restore MySQL 8.0 users from mariadb-dump file

USE `test`;

CREATE USER `jan`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

CREATE USER `mysql.infoschema`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

CREATE USER `mysql.session`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

CREATE USER `mysql.sys`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

CREATE USER `root`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

CREATE USER `sst`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '*5E9A0E9EEA49EEC03272F70AF28D2C19B85DF4C9' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

SELECT COALESCE(CURRENT_ROLE(),'NONE') into @current_role;

CREATE ROLE IF NOT EXISTS mariadb_dump_import_role;

GRANT mariadb_dump_import_role TO CURRENT_USER();

SET ROLE mariadb_dump_import_role;

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 `jan`@`localhost`;

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `jan`@`localhost`;

/*M!100005 SET DEFAULT ROLE NONE FOR 'jan'@'localhost' */;

/*!80001 ALTER USER 'jan'@'localhost' DEFAULT ROLE NONE */;

GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;

GRANT AUDIT_ABORT_EXEMPT,FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.infoschema`@`localhost`;

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.infoschema'@'localhost' */;

/*!80001 ALTER USER 'mysql.infoschema'@'localhost' DEFAULT ROLE NONE */;

GRANT SHUTDOWN, SUPER ON *.* TO `mysql.session`@`localhost`;

GRANT AUDIT_ABORT_EXEMPT,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,FIREWALL_EXEMPT,PERSIST_RO_VARIABLES_ADMIN,SESSION_VARIABLES_ADMIN,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN ON *.* TO `mysql.session`@`localhost`;

GRANT SELECT ON `performance_schema`.* TO `mysql.session`@`localhost`;

GRANT SELECT ON `mysql`.`user` TO `mysql.session`@`localhost`;

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.session'@'localhost' */;

/*!80001 ALTER USER 'mysql.session'@'localhost' DEFAULT ROLE NONE */;

GRANT USAGE ON *.* TO `mysql.sys`@`localhost`;

GRANT AUDIT_ABORT_EXEMPT,FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.sys`@`localhost`;

GRANT TRIGGER ON `sys`.* TO `mysql.sys`@`localhost`;

GRANT SELECT ON `sys`.`sys_config` TO `mysql.sys`@`localhost`;

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.sys'@'localhost' */;

/*!80001 ALTER USER 'mysql.sys'@'localhost' DEFAULT ROLE NONE */;

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 `root`@`localhost` WITH GRANT OPTION;

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION;

GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION;

/*M!100005 SET DEFAULT ROLE NONE FOR 'root'@'localhost' */;

/*!80001 ALTER USER 'root'@'localhost' DEFAULT ROLE NONE */;

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 `sst`@`localhost`;

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `sst`@`localhost`;

/*M!100005 SET DEFAULT ROLE NONE FOR 'sst'@'localhost' */;

/*!80001 ALTER USER 'sst'@'localhost' DEFAULT ROLE NONE */;

SET ROLE NONE;

DROP ROLE mariadb_dump_import_role;

/*M!100203 EXECUTE IMMEDIATE CONCAT('SET ROLE ', @current_role) */;

jan@jan-ThinkPad-P1-Gen-6:~/galeradb$ more mariadb-dump.out

jan@jan-ThinkPad-P1-Gen-6:~/work/mariadb/11.4/mysql-test$ /opt/mariadb-11.4.6-linux-x86_64/bin/mysql -v -v -u root -S /home/jan/work/mariadb/11.4/mysql-test/var/tmp/mysqld.1.sock

/opt/mariadb-11.4.6-linux-x86_64/bin/mysql: Deprecated program name. It will be removed in a future release, use '/opt/mariadb-11.4.6-linux-x86_64/bin/mariadb' instead

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 10

Server version: 11.4.6-MariaDB-debug-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Reading history-file /home/jan/.mysql_history

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> source /home/jan/galeradb/mariadb-dump.sql

Database changed

--------------

CREATE USER `jan`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 2 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

CREATE USER `mysql.infoschema`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 3 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

CREATE USER `mysql.session`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 4 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

CREATE USER `mysql.sys`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 5 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

CREATE USER `root`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 6 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

CREATE USER `sst`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '*5E9A0E9EEA49EEC03272F70AF28D2C19B85DF4C9' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT

--------------

ERROR 1064 (42000) at line 7 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CUR...' at line 1

--------------

SELECT COALESCE(CURRENT_ROLE(),'NONE') into @current_role

--------------

Query OK, 1 row affected (0.000 sec)

--------------

CREATE ROLE IF NOT EXISTS mariadb_dump_import_role

--------------

Query OK, 0 rows affected (0.013 sec)

--------------

GRANT mariadb_dump_import_role TO CURRENT_USER()

--------------

Query OK, 0 rows affected (0.003 sec)

--------------

SET ROLE mariadb_dump_import_role

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

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 `jan`@`localhost`

--------------

ERROR 1064 (42000) at line 12 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ROLE, DROP ROLE ON *.* TO `jan`@`localhost`' at line 1

--------------

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `jan`@`localhost`

--------------

ERROR 1064 (42000) at line 13 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLO...' at line 1

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'jan'@'localhost' */

--------------

ERROR 1960 (0L000) at line 14 in file: '/home/jan/galeradb/mariadb-dump.sql': The current user is invalid

--------------

/*!80001 ALTER USER 'jan'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`

--------------

ERROR 1133 (28000) at line 16 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

GRANT AUDIT_ABORT_EXEMPT,FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.infoschema`@`localhost`

--------------

ERROR 1064 (42000) at line 17 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.infoschema`@`localhost`' at line 1

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.infoschema'@'localhost' */

--------------

ERROR 1960 (0L000) at line 18 in file: '/home/jan/galeradb/mariadb-dump.sql': The current user is invalid

--------------

/*!80001 ALTER USER 'mysql.infoschema'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

GRANT SHUTDOWN, SUPER ON *.* TO `mysql.session`@`localhost`

--------------

ERROR 1133 (28000) at line 20 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

GRANT AUDIT_ABORT_EXEMPT,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,FIREWALL_EXEMPT,PERSIST_RO_VARIABLES_ADMIN,SESSION_VARIABLES_ADMIN,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN ON *.* TO `mysql.session`@`localhost`

--------------

ERROR 1064 (42000) at line 21 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,FIREWAL...' at line 1

--------------

GRANT SELECT ON `performance_schema`.* TO `mysql.session`@`localhost`

--------------

ERROR 1133 (28000) at line 22 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

GRANT SELECT ON `mysql`.`user` TO `mysql.session`@`localhost`

--------------

ERROR 1133 (28000) at line 23 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.session'@'localhost' */

--------------

ERROR 1960 (0L000) at line 24 in file: '/home/jan/galeradb/mariadb-dump.sql': The current user is invalid

--------------

/*!80001 ALTER USER 'mysql.session'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

GRANT USAGE ON *.* TO `mysql.sys`@`localhost`

--------------

ERROR 1133 (28000) at line 26 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

GRANT AUDIT_ABORT_EXEMPT,FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.sys`@`localhost`

--------------

ERROR 1064 (42000) at line 27 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FIREWALL_EXEMPT,SYSTEM_USER ON *.* TO `mysql.sys`@`localhost`' at line 1

--------------

GRANT TRIGGER ON `sys`.* TO `mysql.sys`@`localhost`

--------------

ERROR 1133 (28000) at line 28 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

GRANT SELECT ON `sys`.`sys_config` TO `mysql.sys`@`localhost`

--------------

ERROR 1133 (28000) at line 29 in file: '/home/jan/galeradb/mariadb-dump.sql': Can't find any matching row in the user table

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'mysql.sys'@'localhost' */

--------------

ERROR 1960 (0L000) at line 30 in file: '/home/jan/galeradb/mariadb-dump.sql': The current user is invalid

--------------

/*!80001 ALTER USER 'mysql.sys'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

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 `root`@`localhost` WITH GRANT OPTION

--------------

ERROR 1064 (42000) at line 32 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION' at line 1

--------------

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION

--------------

ERROR 1064 (42000) at line 33 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLO...' at line 1

--------------

GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION

--------------

Query OK, 0 rows affected (0.002 sec)

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'root'@'localhost' */

--------------

Query OK, 0 rows affected (0.002 sec)

--------------

/*!80001 ALTER USER 'root'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

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 `sst`@`localhost`

--------------

ERROR 1064 (42000) at line 37 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ROLE, DROP ROLE ON *.* TO `sst`@`localhost`' at line 1

--------------

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `sst`@`localhost`

--------------

ERROR 1064 (42000) at line 38 in file: '/home/jan/galeradb/mariadb-dump.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLO...' at line 1

--------------

/*M!100005 SET DEFAULT ROLE NONE FOR 'sst'@'localhost' */

--------------

ERROR 1960 (0L000) at line 39 in file: '/home/jan/galeradb/mariadb-dump.sql': The current user is invalid

--------------

/*!80001 ALTER USER 'sst'@'localhost' DEFAULT ROLE NONE */

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

SET ROLE NONE

--------------

Query OK, 0 rows affected (0.000 sec)

--------------

DROP ROLE mariadb_dump_import_role

--------------

Query OK, 0 rows affected (0.002 sec)

--------------

/*M!100203 EXECUTE IMMEDIATE CONCAT('SET ROLE ', @current_role) */

--------------

Query OK, 0 rows affected (0.000 sec)