Server version: 10.2.34-MariaDB Source distribution

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

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

MariaDB [(none)]> show create user;

+-----------------------------------------------------------------------------------------------------------+

| CREATE USER for mariadb_test_restore@%                                                                    |

+-----------------------------------------------------------------------------------------------------------+

| CREATE USER 'mariadb_test_restore'@'%' IDENTIFIED BY PASSWORD '*31B0F6BDDC1774AE174CCB881C3E73B8404679DB' |

+-----------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> show grants;

+------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for mariadb_test_restore@%                                                                                                              |

+------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'mariadb_test_restore'@'%' IDENTIFIED BY PASSWORD '*31B0F6BDDC1774AE174CCB881C3E73B8404679DB' WITH GRANT OPTION |

| GRANT ALL PRIVILEGES ON `mysql`.* TO 'mariadb_test_restore'@'%'                                                                                |

+------------------------------------------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

MariaDB [(none)]> show create user root@localhost;

+--------------------------------+

| CREATE USER for root@localhost |

+--------------------------------+

| CREATE USER 'root'@'localhost' |

+--------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> show grants for root@localhost;

+---------------------------------------------------------------------+

| Grants for root@localhost                                           |

+---------------------------------------------------------------------+

| GRANT role_1 TO 'root'@'localhost' WITH ADMIN OPTION                |

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |

+---------------------------------------------------------------------+

2 rows in set (0.00 sec)

MariaDB [(none)]> Bye

[dan@linux build-mariadb-server-10.2]$ mc -u mariadb_test_restore -pgetitback <  /home/dan/repos/build-mariadb-server-10.2/mysql-test/var/tmp/dump1.sql

ERROR 1698 (28000) at line 24: Access denied for user 'mariadb_test_restore'@'localhost'

-- MySQL dump 10.16  Distrib 10.2.34-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: 

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

-- Server version	10.2.34-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE /*M!100103 OR REPLACE */ USER 'root'@'localhost';

CREATE /*M!100103 OR REPLACE */ USER 'bob'@'%';

CREATE /*M!100103 OR REPLACE */ USER 'root'@'127.0.0.1';

CREATE /*M!100103 OR REPLACE */ USER 'root'@'::1';

/*M!100103 CREATE OR REPLACE ROLE 'role_1' WITH ADMIN 'root'@'localhost' */;

/*M!100103 CREATE OR REPLACE ROLE 'role_2' WITH ADMIN 'role_1' */;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION;