Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/main/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 50 kB

Quelle mysqldump-system.result Sprache: Lisp

install soname 'auth_test_plugin';
#
# MDEV-23630: mysqldump to logically dump system tables
#
#
create table backup_users like mysql.global_priv;
create table tables_priv like mysql.tables_priv;
insert into backup_users select * from mysql.global_priv;
insert into tables_priv select * from mysql.tables_priv;
delete from mysql.global_priv where host not in ('localhost');
flush privileges;
alter user 'mariadb.sys'@'localhost' ACCOUNT UNLOCK;
create user foobar IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
CREATE ROLE role_1;
CREATE ROLE role_2 WITH ADMIN role_1;
GRANT SHOW DATABASES ON *.* TO role_1;
GRANT role_1 TO foobar;
GRANT role_2 TO foobar;
SET DEFAULT ROLE role_2 FOR foobar;
ALTER TABLE mysql.roles_mapping ORDER BY Host, User, Role;
set @save_innodb_stats_persistent= @@innodb_stats_persistent;
create table test.tz like mysql.time_zone_transition;
alter table test.tz engine=innodb;
insert into test.tz select * from mysql.time_zone_transition;
set global innodb_stats_persistent=1;
set time_zone="+03:00";
SET TIMESTAMP= UNIX_TIMESTAMP('2022-01-07 07:07:00');
ANALYZE TABLE test.tz PERSISTENT FOR ALL;
Table Op Msg_type Msg_text
test.tz analyze status Engine-independent statistics collected
test.tz analyze status OK
delete from mysql.index_stats where prefix_arity!=1;
delete from mysql.column_stats where column_name!='Time_zone_id';
update mysql.innodb_index_stats set last_update="2020-01-01" where database_name="test" and table_name="tz";
update mysql.innodb_table_stats set last_update="2020-01-01" where database_name="test" and table_name="tz";
update mysql.column_stats set histogram=json_replace(histogram, '$.collected_by', replace(json_value(histogram, '$.collected_by'), @@version, 'version'));
set global innodb_stats_persistent= @save_innodb_stats_persistent;
alter table mysql.time_zone_name ORDER BY Name;
CREATE SERVER s1 FOREIGN DATA WRAPPER mysql
OPTIONS (HOST 'localhost', DATABASE 'd''b', USER 'o''brien', PASSWORD 'pw''d');
CREATE SERVER `s'2` FOREIGN DATA WRAPPER 'my''sql'
  OPTIONS (HOST 'h2', DATABASE 'db2', USER 'u2');
create server `s``3` foreign data wrapper mysql options (host 'value');
CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME "UDF_EXAMPLE_LIB";
#
# mysqldump of system tables with --system=all
#
/*M!999999\- enable the sandbox mode */

/*!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 utf8mb4 */;
/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
INSTALL PLUGIN `test_plugin_server`  SONAME 'AUTH_TEST_PLUGIN_LIB';
INSTALL PLUGIN `cleartext_plugin_server`  SONAME 'AUTH_TEST_PLUGIN_LIB';
CREATE USER `mariadb.sys`@`localhost` PASSWORD EXPIRE;
CREATE USER `root`@`localhost`;
CREATE USER `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
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;
/*!80001 CREATE ROLE 'role_1' */;
/*M!100005 CREATE ROLE 'role_1' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_1' TO 'root'@'localhost' WITH ADMIN OPTION */;
/*!80001 CREATE ROLE 'role_2' */;
/*M!100005 CREATE ROLE 'role_2' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_2' TO 'role_1' WITH ADMIN OPTION */;
GRANT USAGE ON *.* TO `mariadb.sys`@`localhost`;
GRANT SELECT, DELETE ON `mysql`.`global_priv` TO `mariadb.sys`@`localhost`;
/*M!100005 SET DEFAULT ROLE NONE FOR 'mariadb.sys'@'localhost' */;
/*!80001 ALTER USER 'mariadb.sys'@'localhost' DEFAULT ROLE NONE */;
GRANT `role_1` TO `root`@`localhost` WITH ADMIN OPTION;
GRANT ALL PRIVILEGES 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 `role_1` TO `foobar`@`%`;
GRANT `role_2` TO `foobar`@`%`;
GRANT USAGE ON *.* TO `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
/*M!100005 SET DEFAULT ROLE 'role_2' FOR 'foobar'@'%' */;
/*!80001 ALTER USER 'foobar'@'%' DEFAULT ROLE 'role_2' */;
GRANT `role_2` TO `role_1` WITH ADMIN OPTION;
GRANT SHOW DATABASES ON *.* TO `role_1`;
GRANT USAGE ON *.* TO `role_2`;
GRANT USAGE ON *.* TO `role_2`;
SET ROLE NONE;
DROP ROLE mariadb_dump_import_role;
/*M!100203 EXECUTE IMMEDIATE CONCAT('SET ROLE ', @current_role) */;
CREATE FUNCTION `metaphon` RETURNS STRING SONAME 'UDF_EXAMPLE_LIB';
CREATE AGGREGATE FUNCTION `avgcost` RETURNS REAL SONAME 'UDF_EXAMPLE_LIB';
CREATE SERVER `s'2` FOREIGN DATA WRAPPER `my'sql` OPTIONS (`HOST` 'h2', `DATABASE` 'db2', `USER` 'u2');
CREATE SERVER `s1` FOREIGN DATA WRAPPER `mysql` OPTIONS (`HOST` 'localhost', `DATABASE` 'd''b', `USER` 'o''brien', `PASSWORD` 'pw''d');
CREATE SERVER `s``3` FOREIGN DATA WRAPPER `mysql` OPTIONS (`host` 'value');

USE mysql;

LOCK TABLES `column_stats` WRITE;
/*!40000 ALTER TABLE `column_stats` DISABLE KEYS */;
REPLACE INTO `column_stats` VALUES
('test','tz','Time_zone_id','1','6',0.0000,4.0000,78.8000,4,'JSON_HB','{\"target_histogram_size\": 254, \"collected_at\": \"2022-01-07 07:07:00\", \"collected_by\": \"version\", \"histogram_hb\": [{\"start\": \"1\", \"size\": 0.340101523, \"ndv\": 1}, {\"start\": \"3\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"4\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"5\", \"end\": \"6\", \"size\": 0.005076142, \"ndv\": 2}]}');
/*!40000 ALTER TABLE `column_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `index_stats` WRITE;
/*!40000 ALTER TABLE `index_stats` DISABLE KEYS */;
REPLACE INTO `index_stats` VALUES
('test','tz','PRIMARY',1,78.8000);
/*!40000 ALTER TABLE `index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `table_stats` WRITE;
/*!40000 ALTER TABLE `table_stats` DISABLE KEYS */;
REPLACE INTO `table_stats` VALUES
('test','tz',394);
/*!40000 ALTER TABLE `table_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_index_stats` WRITE;
/*!40000 ALTER TABLE `innodb_index_stats` DISABLE KEYS */;
REPLACE INTO `innodb_index_stats` VALUES
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx01',5,1,'Time_zone_id'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx02',394,1,'Time_zone_id,Transition_time'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),
('test','tz','PRIMARY','2019-12-31 21:00:00','size',1,NULL,'Number of pages in the index');
/*!40000 ALTER TABLE `innodb_index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_table_stats` WRITE;
/*!40000 ALTER TABLE `innodb_table_stats` DISABLE KEYS */;
REPLACE INTO `innodb_table_stats` VALUES
('test','tz','2019-12-31 21:00:00',394,1,0);
/*!40000 ALTER TABLE `innodb_table_stats` ENABLE KEYS */;
UNLOCK TABLES;

USE mysql;

LOCK TABLES `time_zone` WRITE;
/*!40000 ALTER TABLE `time_zone` DISABLE KEYS */;
REPLACE INTO `time_zone` VALUES
(1,'N'),
(2,'N'),
(3,'N'),
(4,'Y'),
(5,'N'),
(6,'Y');
/*!40000 ALTER TABLE `time_zone` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_name` WRITE;
/*!40000 ALTER TABLE `time_zone_name` DISABLE KEYS */;
REPLACE INTO `time_zone_name` VALUES
('Europe/Moscow',3),
('India/Kolkata',6),
('Japan',5),
('leap/Europe/Moscow',4),
('MET',1),
('Universal',2),
('UTC',2);
/*!40000 ALTER TABLE `time_zone_name` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_leap_second` WRITE;
/*!40000 ALTER TABLE `time_zone_leap_second` DISABLE KEYS */;
REPLACE INTO `time_zone_leap_second` VALUES
(174834660,1),
(78796800,1),
(94694401,2),
(126230402,3),
(157766403,4),
(189302404,5),
(220924805,6),
(252460806,7),
(283996807,8),
(315532808,9),
(362793609,10),
(394329610,11),
(425865611,12),
(489024012,13),
(567993613,14),
(631152014,15),
(662688015,16),
(709948816,17),
(741484817,18),
(773020818,19),
(820454419,20),
(867715220,21),
(915148821,22);
/*!40000 ALTER TABLE `time_zone_leap_second` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition` WRITE;
/*!40000 ALTER TABLE `time_zone_transition` DISABLE KEYS */;
REPLACE INTO `time_zone_transition` VALUES
(1,-1693706400,0),
(1,-1680483600,1),
(1,-1663455600,2),
(1,-1650150000,3),
(1,-1632006000,2),
(1,-1618700400,3),
(1,-938905200,2),
(1,-857257200,3),
(1,-844556400,2),
(1,-828226800,3),
(1,-812502000,2),
(1,-796777200,3),
(1,228877200,2),
(1,243997200,3),
(1,260326800,2),
(1,276051600,3),
(1,291776400,2),
(1,307501200,3),
(1,323830800,2),
(1,338950800,3),
(1,354675600,2),
(1,370400400,3),
(1,386125200,2),
(1,401850000,3),
(1,417574800,2),
(1,433299600,3),
(1,449024400,2),
(1,465354000,3),
(1,481078800,2),
(1,496803600,3),
(1,512528400,2),
(1,528253200,3),
(1,543978000,2),
(1,559702800,3),
(1,575427600,2),
(1,591152400,3),
(1,606877200,2),
(1,622602000,3),
(1,638326800,2),
(1,654656400,3),
(1,670381200,2),
(1,686106000,3),
(1,701830800,2),
(1,717555600,3),
(1,733280400,2),
(1,749005200,3),
(1,764730000,2),
(1,780454800,3),
(1,796179600,2),
(1,811904400,3),
(1,828234000,2),
(1,846378000,3),
(1,859683600,2),
(1,877827600,3),
(1,891133200,2),
(1,909277200,3),
(1,922582800,2),
(1,941331600,3),
(1,954032400,2),
(1,972781200,3),
(1,985482000,2),
(1,1004230800,3),
(1,1017536400,2),
(1,1035680400,3),
(1,1048986000,2),
(1,1067130000,3),
(1,1080435600,2),
(1,1099184400,3),
(1,1111885200,2),
(1,1130634000,3),
(1,1143334800,2),
(1,1162083600,3),
(1,1174784400,2),
(1,1193533200,3),
(1,1206838800,2),
(1,1224982800,3),
(1,1238288400,2),
(1,1256432400,3),
(1,1269738000,2),
(1,1288486800,3),
(1,1301187600,2),
(1,1319936400,3),
(1,1332637200,2),
(1,1351386000,3),
(1,1364691600,2),
(1,1382835600,3),
(1,1396141200,2),
(1,1414285200,3),
(1,1427590800,2),
(1,1445734800,3),
(1,1459040400,2),
(1,1477789200,3),
(1,1490490000,2),
(1,1509238800,3),
(1,1521939600,2),
(1,1540688400,3),
(1,1553994000,2),
(1,1572138000,3),
(1,1585443600,2),
(1,1603587600,3),
(1,1616893200,2),
(1,1635642000,3),
(1,1648342800,2),
(1,1667091600,3),
(1,1679792400,2),
(1,1698541200,3),
(1,1711846800,2),
(1,1729990800,3),
(1,1743296400,2),
(1,1761440400,3),
(1,1774746000,2),
(1,1792890000,3),
(1,1806195600,2),
(1,1824944400,3),
(1,1837645200,2),
(1,1856394000,3),
(1,1869094800,2),
(1,1887843600,3),
(1,1901149200,2),
(1,1919293200,3),
(1,1932598800,2),
(1,1950742800,3),
(1,1964048400,2),
(1,1982797200,3),
(1,1995498000,2),
(1,2014246800,3),
(1,2026947600,2),
(1,2045696400,3),
(1,2058397200,2),
(1,2077146000,3),
(1,2090451600,2),
(1,2108595600,3),
(1,2121901200,2),
(1,2140045200,3),
(3,-1688265000,2),
(3,-1656819048,1),
(3,-1641353448,2),
(3,-1627965048,3),
(3,-1618716648,1),
(3,-1596429048,3),
(3,-1593829848,5),
(3,-1589860800,4),
(3,-1542427200,5),
(3,-1539493200,6),
(3,-1525323600,5),
(3,-1522728000,4),
(3,-1491188400,7),
(3,-1247536800,4),
(3,354920400,5),
(3,370728000,4),
(3,386456400,5),
(3,402264000,4),
(3,417992400,5),
(3,433800000,4),
(3,449614800,5),
(3,465346800,8),
(3,481071600,9),
(3,496796400,8),
(3,512521200,9),
(3,528246000,8),
(3,543970800,9),
(3,559695600,8),
(3,575420400,9),
(3,591145200,8),
(3,606870000,9),
(3,622594800,8),
(3,638319600,9),
(3,654649200,8),
(3,670374000,10),
(3,686102400,11),
(3,695779200,8),
(3,701812800,5),
(3,717534000,4),
(3,733273200,9),
(3,748998000,8),
(3,764722800,9),
(3,780447600,8),
(3,796172400,9),
(3,811897200,8),
(3,828226800,9),
(3,846370800,8),
(3,859676400,9),
(3,877820400,8),
(3,891126000,9),
(3,909270000,8),
(3,922575600,9),
(3,941324400,8),
(3,954025200,9),
(3,972774000,8),
(3,985474800,9),
(3,1004223600,8),
(3,1017529200,9),
(3,1035673200,8),
(3,1048978800,9),
(3,1067122800,8),
(3,1080428400,9),
(3,1099177200,8),
(3,1111878000,9),
(3,1130626800,8),
(3,1143327600,9),
(3,1162076400,8),
(3,1174777200,9),
(3,1193526000,8),
(3,1206831600,9),
(3,1224975600,8),
(3,1238281200,9),
(3,1256425200,8),
(3,1269730800,9),
(3,1288479600,8),
(3,1301180400,9),
(3,1319929200,8),
(3,1332630000,9),
(3,1351378800,8),
(3,1364684400,9),
(3,1382828400,8),
(3,1396134000,9),
(3,1414278000,8),
(3,1427583600,9),
(3,1445727600,8),
(3,1459033200,9),
(3,1477782000,8),
(3,1490482800,9),
(3,1509231600,8),
(3,1521932400,9),
(3,1540681200,8),
(3,1553986800,9),
(3,1572130800,8),
(3,1585436400,9),
(3,1603580400,8),
(3,1616886000,9),
(3,1635634800,8),
(3,1648335600,9),
(3,1667084400,8),
(3,1679785200,9),
(3,1698534000,8),
(3,1711839600,9),
(3,1729983600,8),
(3,1743289200,9),
(3,1761433200,8),
(3,1774738800,9),
(3,1792882800,8),
(3,1806188400,9),
(3,1824937200,8),
(3,1837638000,9),
(3,1856386800,8),
(3,1869087600,9),
(3,1887836400,8),
(3,1901142000,9),
(3,1919286000,8),
(3,1932591600,9),
(3,1950735600,8),
(3,1964041200,9),
(3,1982790000,8),
(3,1995490800,9),
(3,2014239600,8),
(3,2026940400,9),
(3,2045689200,8),
(3,2058390000,9),
(3,2077138800,8),
(3,2090444400,9),
(3,2108588400,8),
(3,2121894000,9),
(3,2140038000,8),
(4,-1688265000,2),
(4,-1656819048,1),
(4,-1641353448,2),
(4,-1627965048,3),
(4,-1618716648,1),
(4,-1596429048,3),
(4,-1593829848,5),
(4,-1589860800,4),
(4,-1542427200,5),
(4,-1539493200,6),
(4,-1525323600,5),
(4,-1522728000,4),
(4,-1491188400,7),
(4,-1247536800,4),
(4,354920409,5),
(4,370728010,4),
(4,386456410,5),
(4,402264011,4),
(4,417992411,5),
(4,433800012,4),
(4,449614812,5),
(4,465346812,8),
(4,481071612,9),
(4,496796413,8),
(4,512521213,9),
(4,528246013,8),
(4,543970813,9),
(4,559695613,8),
(4,575420414,9),
(4,591145214,8),
(4,606870014,9),
(4,622594814,8),
(4,638319615,9),
(4,654649215,8),
(4,670374016,10),
(4,686102416,11),
(4,695779216,8),
(4,701812816,5),
(4,717534017,4),
(4,733273217,9),
(4,748998018,8),
(4,764722818,9),
(4,780447619,8),
(4,796172419,9),
(4,811897219,8),
(4,828226820,9),
(4,846370820,8),
(4,859676420,9),
(4,877820421,8),
(4,891126021,9),
(4,909270021,8),
(4,922575622,9),
(4,941324422,8),
(4,954025222,9),
(4,972774022,8),
(4,985474822,9),
(4,1004223622,8),
(4,1017529222,9),
(4,1035673222,8),
(4,1048978822,9),
(4,1067122822,8),
(4,1080428422,9),
(4,1099177222,8),
(4,1111878022,9),
(4,1130626822,8),
(4,1143327622,9),
(4,1162076422,8),
(4,1174777222,9),
(4,1193526022,8),
(4,1206831622,9),
(4,1224975622,8),
(4,1238281222,9),
(4,1256425222,8),
(4,1269730822,9),
(4,1288479622,8),
(4,1301180422,9),
(4,1319929222,8),
(4,1332630022,9),
(4,1351378822,8),
(4,1364684422,9),
(4,1382828422,8),
(4,1396134022,9),
(4,1414278022,8),
(4,1427583622,9),
(4,1445727622,8),
(4,1459033222,9),
(4,1477782022,8),
(4,1490482822,9),
(4,1509231622,8),
(4,1521932422,9),
(4,1540681222,8),
(4,1553986822,9),
(4,1572130822,8),
(4,1585436422,9),
(4,1603580422,8),
(4,1616886022,9),
(4,1635634822,8),
(4,1648335622,9),
(4,1667084422,8),
(4,1679785222,9),
(4,1698534022,8),
(4,1711839622,9),
(4,1729983622,8),
(4,1743289222,9),
(4,1761433222,8),
(4,1774738822,9),
(4,1792882822,8),
(4,1806188422,9),
(4,1824937222,8),
(4,1837638022,9),
(4,1856386822,8),
(4,1869087622,9),
(4,1887836422,8),
(4,1901142022,9),
(4,1919286022,8),
(4,1932591622,9),
(4,1950735622,8),
(4,1964041222,9),
(4,1982790022,8),
(4,1995490822,9),
(4,2014239622,8),
(4,2026940422,9),
(4,2045689222,8),
(4,2058390022,9),
(4,2077138822,8),
(4,2090444422,9),
(4,2108588422,8),
(4,2121894022,9),
(4,2140038022,8),
(5,-1009875600,1),
(6,174834660,1);
/*!40000 ALTER TABLE `time_zone_transition` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition_type` WRITE;
/*!40000 ALTER TABLE `time_zone_transition_type` DISABLE KEYS */;
REPLACE INTO `time_zone_transition_type` VALUES
(1,0,7200,1,'MEST'),
(1,1,3600,0,'MET'),
(1,2,7200,1,'MEST'),
(1,3,3600,0,'MET'),
(2,0,0,0,'UTC'),
(3,0,9000,0,'MMT'),
(3,1,12648,1,'MST'),
(3,2,9048,0,'MMT'),
(3,3,16248,1,'MDST'),
(3,4,10800,0,'MSK'),
(3,5,14400,1,'MSD'),
(3,6,18000,1,'MSD'),
(3,7,7200,0,'EET'),
(3,8,10800,0,'MSK'),
(3,9,14400,1,'MSD'),
(3,10,10800,1,'EEST'),
(3,11,7200,0,'EET'),
(4,0,9000,0,'MMT'),
(4,1,12648,1,'MST'),
(4,2,9048,0,'MMT'),
(4,3,16248,1,'MDST'),
(4,4,10800,0,'MSK'),
(4,5,14400,1,'MSD'),
(4,6,18000,1,'MSD'),
(4,7,7200,0,'EET'),
(4,8,10800,0,'MSK'),
(4,9,14400,1,'MSD'),
(4,10,10800,1,'EEST'),
(4,11,7200,0,'EET'),
(5,0,32400,0,'CJT'),
(5,1,32400,0,'JST'),
(6,1,19800,0,'IST');
/*!40000 ALTER TABLE `time_zone_transition_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

#
# mysqldump of system tables with --system=all --replace
#
/*M!999999\- enable the sandbox mode */

/*!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 utf8mb4 */;
/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
/*M!100401 UNINSTALL PLUGIN IF EXIST `test_plugin_server` */;
INSTALL PLUGIN `test_plugin_server`  SONAME 'AUTH_TEST_PLUGIN_LIB';
/*M!100401 UNINSTALL PLUGIN IF EXIST `cleartext_plugin_server` */;
INSTALL PLUGIN `cleartext_plugin_server`  SONAME 'AUTH_TEST_PLUGIN_LIB';
DELIMITER |
/*M!100101 IF current_user()='''mariadb.sys''@''localhost''' THEN
  SIGNAL SQLSTATE '45000' SET MYSQL_ERRNO=30001, MESSAGE_TEXT="Don't remove current user 'mariadb.sys'@'localhost''";
END IF */|
DELIMITER ;
/*!50701 DROP USER IF EXISTS 'mariadb.sys'@'localhost' */;
CREATE /*M!100103 OR REPLACE */ USER `mariadb.sys`@`localhost` PASSWORD EXPIRE;
DELIMITER |
/*M!100101 IF current_user()='''root''@''localhost''' THEN
  SIGNAL SQLSTATE '45000' SET MYSQL_ERRNO=30001, MESSAGE_TEXT="Don't remove current user 'root'@'localhost''";
END IF */|
DELIMITER ;
/*!50701 DROP USER IF EXISTS 'root'@'localhost' */;
CREATE /*M!100103 OR REPLACE */ USER `root`@`localhost`;
DELIMITER |
/*M!100101 IF current_user()='''foobar''@''%''' THEN
  SIGNAL SQLSTATE '45000' SET MYSQL_ERRNO=30001, MESSAGE_TEXT="Don't remove current user 'foobar'@'%''";
END IF */|
DELIMITER ;
/*!50701 DROP USER IF EXISTS 'foobar'@'%' */;
CREATE /*M!100103 OR REPLACE */ USER `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
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;
/*!80001 DROP ROLE IF EXISTS 'role_1' */;
/*!80001 CREATE ROLE 'role_1' */;
/*M!100103 CREATE OR REPLACE ROLE 'role_1' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_1' TO 'root'@'localhost' WITH ADMIN OPTION */;
/*!80001 DROP ROLE IF EXISTS 'role_2' */;
/*!80001 CREATE ROLE 'role_2' */;
/*M!100103 CREATE OR REPLACE ROLE 'role_2' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_2' TO 'role_1' WITH ADMIN OPTION */;
GRANT USAGE ON *.* TO `mariadb.sys`@`localhost`;
GRANT SELECT, DELETE ON `mysql`.`global_priv` TO `mariadb.sys`@`localhost`;
/*M!100005 SET DEFAULT ROLE NONE FOR 'mariadb.sys'@'localhost' */;
/*!80001 ALTER USER 'mariadb.sys'@'localhost' DEFAULT ROLE NONE */;
GRANT `role_1` TO `root`@`localhost` WITH ADMIN OPTION;
GRANT ALL PRIVILEGES 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 `role_1` TO `foobar`@`%`;
GRANT `role_2` TO `foobar`@`%`;
GRANT USAGE ON *.* TO `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
/*M!100005 SET DEFAULT ROLE 'role_2' FOR 'foobar'@'%' */;
/*!80001 ALTER USER 'foobar'@'%' DEFAULT ROLE 'role_2' */;
GRANT `role_2` TO `role_1` WITH ADMIN OPTION;
GRANT SHOW DATABASES ON *.* TO `role_1`;
GRANT USAGE ON *.* TO `role_2`;
GRANT USAGE ON *.* TO `role_2`;
SET ROLE NONE;
DROP ROLE mariadb_dump_import_role;
/*M!100203 EXECUTE IMMEDIATE CONCAT('SET ROLE ', @current_role) */;
/*!50701 DROP FUNCTION IF EXISTS `metaphon` */;
CREATE /*M!100103 OR REPLACE */ FUNCTION `metaphon` RETURNS STRING SONAME 'UDF_EXAMPLE_LIB';
/*!50701 DROP FUNCTION IF EXISTS `avgcost` */;
CREATE /*M!100103 OR REPLACE */ AGGREGATE FUNCTION `avgcost` RETURNS REAL SONAME 'UDF_EXAMPLE_LIB';
CREATE /*M!100103 OR REPLACE */ SERVER `s'2` FOREIGN DATA WRAPPER `my'sql` OPTIONS (`HOST` 'h2', `DATABASE` 'db2', `USER` 'u2');
CREATE /*M!100103 OR REPLACE */ SERVER `s1` FOREIGN DATA WRAPPER `mysql` OPTIONS (`HOST` 'localhost', `DATABASE` 'd''b', `USER` 'o''brien', `PASSWORD` 'pw''d');
CREATE /*M!100103 OR REPLACE */ SERVER `s``3` FOREIGN DATA WRAPPER `mysql` OPTIONS (`host` 'value');

USE mysql;

LOCK TABLES `column_stats` WRITE;
/*!40000 ALTER TABLE `column_stats` DISABLE KEYS */;
REPLACE INTO `column_stats` VALUES
('test','tz','Time_zone_id','1','6',0.0000,4.0000,78.8000,4,'JSON_HB','{\"target_histogram_size\": 254, \"collected_at\": \"2022-01-07 07:07:00\", \"collected_by\": \"version\", \"histogram_hb\": [{\"start\": \"1\", \"size\": 0.340101523, \"ndv\": 1}, {\"start\": \"3\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"4\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"5\", \"end\": \"6\", \"size\": 0.005076142, \"ndv\": 2}]}');
/*!40000 ALTER TABLE `column_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `index_stats` WRITE;
/*!40000 ALTER TABLE `index_stats` DISABLE KEYS */;
REPLACE INTO `index_stats` VALUES
('test','tz','PRIMARY',1,78.8000);
/*!40000 ALTER TABLE `index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `table_stats` WRITE;
/*!40000 ALTER TABLE `table_stats` DISABLE KEYS */;
REPLACE INTO `table_stats` VALUES
('test','tz',394);
/*!40000 ALTER TABLE `table_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_index_stats` WRITE;
/*!40000 ALTER TABLE `innodb_index_stats` DISABLE KEYS */;
REPLACE INTO `innodb_index_stats` VALUES
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx01',5,1,'Time_zone_id'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx02',394,1,'Time_zone_id,Transition_time'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),
('test','tz','PRIMARY','2019-12-31 21:00:00','size',1,NULL,'Number of pages in the index');
/*!40000 ALTER TABLE `innodb_index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_table_stats` WRITE;
/*!40000 ALTER TABLE `innodb_table_stats` DISABLE KEYS */;
REPLACE INTO `innodb_table_stats` VALUES
('test','tz','2019-12-31 21:00:00',394,1,0);
/*!40000 ALTER TABLE `innodb_table_stats` ENABLE KEYS */;
UNLOCK TABLES;

USE mysql;

LOCK TABLES `time_zone` WRITE;
/*!40000 ALTER TABLE `time_zone` DISABLE KEYS */;
REPLACE INTO `time_zone` VALUES
(1,'N'),
(2,'N'),
(3,'N'),
(4,'Y'),
(5,'N'),
(6,'Y');
/*!40000 ALTER TABLE `time_zone` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_name` WRITE;
/*!40000 ALTER TABLE `time_zone_name` DISABLE KEYS */;
REPLACE INTO `time_zone_name` VALUES
('Europe/Moscow',3),
('India/Kolkata',6),
('Japan',5),
('leap/Europe/Moscow',4),
('MET',1),
('Universal',2),
('UTC',2);
/*!40000 ALTER TABLE `time_zone_name` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_leap_second` WRITE;
/*!40000 ALTER TABLE `time_zone_leap_second` DISABLE KEYS */;
REPLACE INTO `time_zone_leap_second` VALUES
(174834660,1),
(78796800,1),
(94694401,2),
(126230402,3),
(157766403,4),
(189302404,5),
(220924805,6),
(252460806,7),
(283996807,8),
(315532808,9),
(362793609,10),
(394329610,11),
(425865611,12),
(489024012,13),
(567993613,14),
(631152014,15),
(662688015,16),
(709948816,17),
(741484817,18),
(773020818,19),
(820454419,20),
(867715220,21),
(915148821,22);
/*!40000 ALTER TABLE `time_zone_leap_second` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition` WRITE;
/*!40000 ALTER TABLE `time_zone_transition` DISABLE KEYS */;
REPLACE INTO `time_zone_transition` VALUES
(1,-1693706400,0),
(1,-1680483600,1),
(1,-1663455600,2),
(1,-1650150000,3),
(1,-1632006000,2),
(1,-1618700400,3),
(1,-938905200,2),
(1,-857257200,3),
(1,-844556400,2),
(1,-828226800,3),
(1,-812502000,2),
(1,-796777200,3),
(1,228877200,2),
(1,243997200,3),
(1,260326800,2),
(1,276051600,3),
(1,291776400,2),
(1,307501200,3),
(1,323830800,2),
(1,338950800,3),
(1,354675600,2),
(1,370400400,3),
(1,386125200,2),
(1,401850000,3),
(1,417574800,2),
(1,433299600,3),
(1,449024400,2),
(1,465354000,3),
(1,481078800,2),
(1,496803600,3),
(1,512528400,2),
(1,528253200,3),
(1,543978000,2),
(1,559702800,3),
(1,575427600,2),
(1,591152400,3),
(1,606877200,2),
(1,622602000,3),
(1,638326800,2),
(1,654656400,3),
(1,670381200,2),
(1,686106000,3),
(1,701830800,2),
(1,717555600,3),
(1,733280400,2),
(1,749005200,3),
(1,764730000,2),
(1,780454800,3),
(1,796179600,2),
(1,811904400,3),
(1,828234000,2),
(1,846378000,3),
(1,859683600,2),
(1,877827600,3),
(1,891133200,2),
(1,909277200,3),
(1,922582800,2),
(1,941331600,3),
(1,954032400,2),
(1,972781200,3),
(1,985482000,2),
(1,1004230800,3),
(1,1017536400,2),
(1,1035680400,3),
(1,1048986000,2),
(1,1067130000,3),
(1,1080435600,2),
(1,1099184400,3),
(1,1111885200,2),
(1,1130634000,3),
(1,1143334800,2),
(1,1162083600,3),
(1,1174784400,2),
(1,1193533200,3),
(1,1206838800,2),
(1,1224982800,3),
(1,1238288400,2),
(1,1256432400,3),
(1,1269738000,2),
(1,1288486800,3),
(1,1301187600,2),
(1,1319936400,3),
(1,1332637200,2),
(1,1351386000,3),
(1,1364691600,2),
(1,1382835600,3),
(1,1396141200,2),
(1,1414285200,3),
(1,1427590800,2),
(1,1445734800,3),
(1,1459040400,2),
(1,1477789200,3),
(1,1490490000,2),
(1,1509238800,3),
(1,1521939600,2),
(1,1540688400,3),
(1,1553994000,2),
(1,1572138000,3),
(1,1585443600,2),
(1,1603587600,3),
(1,1616893200,2),
(1,1635642000,3),
(1,1648342800,2),
(1,1667091600,3),
(1,1679792400,2),
(1,1698541200,3),
(1,1711846800,2),
(1,1729990800,3),
(1,1743296400,2),
(1,1761440400,3),
(1,1774746000,2),
(1,1792890000,3),
(1,1806195600,2),
(1,1824944400,3),
(1,1837645200,2),
(1,1856394000,3),
(1,1869094800,2),
(1,1887843600,3),
(1,1901149200,2),
(1,1919293200,3),
(1,1932598800,2),
(1,1950742800,3),
(1,1964048400,2),
(1,1982797200,3),
(1,1995498000,2),
(1,2014246800,3),
(1,2026947600,2),
(1,2045696400,3),
(1,2058397200,2),
(1,2077146000,3),
(1,2090451600,2),
(1,2108595600,3),
(1,2121901200,2),
(1,2140045200,3),
(3,-1688265000,2),
(3,-1656819048,1),
(3,-1641353448,2),
(3,-1627965048,3),
(3,-1618716648,1),
(3,-1596429048,3),
(3,-1593829848,5),
(3,-1589860800,4),
(3,-1542427200,5),
(3,-1539493200,6),
(3,-1525323600,5),
(3,-1522728000,4),
(3,-1491188400,7),
(3,-1247536800,4),
(3,354920400,5),
(3,370728000,4),
(3,386456400,5),
(3,402264000,4),
(3,417992400,5),
(3,433800000,4),
(3,449614800,5),
(3,465346800,8),
(3,481071600,9),
(3,496796400,8),
(3,512521200,9),
(3,528246000,8),
(3,543970800,9),
(3,559695600,8),
(3,575420400,9),
(3,591145200,8),
(3,606870000,9),
(3,622594800,8),
(3,638319600,9),
(3,654649200,8),
(3,670374000,10),
(3,686102400,11),
(3,695779200,8),
(3,701812800,5),
(3,717534000,4),
(3,733273200,9),
(3,748998000,8),
(3,764722800,9),
(3,780447600,8),
(3,796172400,9),
(3,811897200,8),
(3,828226800,9),
(3,846370800,8),
(3,859676400,9),
(3,877820400,8),
(3,891126000,9),
(3,909270000,8),
(3,922575600,9),
(3,941324400,8),
(3,954025200,9),
(3,972774000,8),
(3,985474800,9),
(3,1004223600,8),
(3,1017529200,9),
(3,1035673200,8),
(3,1048978800,9),
(3,1067122800,8),
(3,1080428400,9),
(3,1099177200,8),
(3,1111878000,9),
(3,1130626800,8),
(3,1143327600,9),
(3,1162076400,8),
(3,1174777200,9),
(3,1193526000,8),
(3,1206831600,9),
(3,1224975600,8),
(3,1238281200,9),
(3,1256425200,8),
(3,1269730800,9),
(3,1288479600,8),
(3,1301180400,9),
(3,1319929200,8),
(3,1332630000,9),
(3,1351378800,8),
(3,1364684400,9),
(3,1382828400,8),
(3,1396134000,9),
(3,1414278000,8),
(3,1427583600,9),
(3,1445727600,8),
(3,1459033200,9),
(3,1477782000,8),
(3,1490482800,9),
(3,1509231600,8),
(3,1521932400,9),
(3,1540681200,8),
(3,1553986800,9),
(3,1572130800,8),
(3,1585436400,9),
(3,1603580400,8),
(3,1616886000,9),
(3,1635634800,8),
(3,1648335600,9),
(3,1667084400,8),
(3,1679785200,9),
(3,1698534000,8),
(3,1711839600,9),
(3,1729983600,8),
(3,1743289200,9),
(3,1761433200,8),
(3,1774738800,9),
(3,1792882800,8),
(3,1806188400,9),
(3,1824937200,8),
(3,1837638000,9),
(3,1856386800,8),
(3,1869087600,9),
(3,1887836400,8),
(3,1901142000,9),
(3,1919286000,8),
(3,1932591600,9),
(3,1950735600,8),
(3,1964041200,9),
(3,1982790000,8),
(3,1995490800,9),
(3,2014239600,8),
(3,2026940400,9),
(3,2045689200,8),
(3,2058390000,9),
(3,2077138800,8),
(3,2090444400,9),
(3,2108588400,8),
(3,2121894000,9),
(3,2140038000,8),
(4,-1688265000,2),
(4,-1656819048,1),
(4,-1641353448,2),
(4,-1627965048,3),
(4,-1618716648,1),
(4,-1596429048,3),
(4,-1593829848,5),
(4,-1589860800,4),
(4,-1542427200,5),
(4,-1539493200,6),
(4,-1525323600,5),
(4,-1522728000,4),
(4,-1491188400,7),
(4,-1247536800,4),
(4,354920409,5),
(4,370728010,4),
(4,386456410,5),
(4,402264011,4),
(4,417992411,5),
(4,433800012,4),
(4,449614812,5),
(4,465346812,8),
(4,481071612,9),
(4,496796413,8),
(4,512521213,9),
(4,528246013,8),
(4,543970813,9),
(4,559695613,8),
(4,575420414,9),
(4,591145214,8),
(4,606870014,9),
(4,622594814,8),
(4,638319615,9),
(4,654649215,8),
(4,670374016,10),
(4,686102416,11),
(4,695779216,8),
(4,701812816,5),
(4,717534017,4),
(4,733273217,9),
(4,748998018,8),
(4,764722818,9),
(4,780447619,8),
(4,796172419,9),
(4,811897219,8),
(4,828226820,9),
(4,846370820,8),
(4,859676420,9),
(4,877820421,8),
(4,891126021,9),
(4,909270021,8),
(4,922575622,9),
(4,941324422,8),
(4,954025222,9),
(4,972774022,8),
(4,985474822,9),
(4,1004223622,8),
(4,1017529222,9),
(4,1035673222,8),
(4,1048978822,9),
(4,1067122822,8),
(4,1080428422,9),
(4,1099177222,8),
(4,1111878022,9),
(4,1130626822,8),
(4,1143327622,9),
(4,1162076422,8),
(4,1174777222,9),
(4,1193526022,8),
(4,1206831622,9),
(4,1224975622,8),
(4,1238281222,9),
(4,1256425222,8),
(4,1269730822,9),
(4,1288479622,8),
(4,1301180422,9),
(4,1319929222,8),
(4,1332630022,9),
(4,1351378822,8),
(4,1364684422,9),
(4,1382828422,8),
(4,1396134022,9),
(4,1414278022,8),
(4,1427583622,9),
(4,1445727622,8),
(4,1459033222,9),
(4,1477782022,8),
(4,1490482822,9),
(4,1509231622,8),
(4,1521932422,9),
(4,1540681222,8),
(4,1553986822,9),
(4,1572130822,8),
(4,1585436422,9),
(4,1603580422,8),
(4,1616886022,9),
(4,1635634822,8),
(4,1648335622,9),
(4,1667084422,8),
(4,1679785222,9),
(4,1698534022,8),
(4,1711839622,9),
(4,1729983622,8),
(4,1743289222,9),
(4,1761433222,8),
(4,1774738822,9),
(4,1792882822,8),
(4,1806188422,9),
(4,1824937222,8),
(4,1837638022,9),
(4,1856386822,8),
(4,1869087622,9),
(4,1887836422,8),
(4,1901142022,9),
(4,1919286022,8),
(4,1932591622,9),
(4,1950735622,8),
(4,1964041222,9),
(4,1982790022,8),
(4,1995490822,9),
(4,2014239622,8),
(4,2026940422,9),
(4,2045689222,8),
(4,2058390022,9),
(4,2077138822,8),
(4,2090444422,9),
(4,2108588422,8),
(4,2121894022,9),
(4,2140038022,8),
(5,-1009875600,1),
(6,174834660,1);
/*!40000 ALTER TABLE `time_zone_transition` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition_type` WRITE;
/*!40000 ALTER TABLE `time_zone_transition_type` DISABLE KEYS */;
REPLACE INTO `time_zone_transition_type` VALUES
(1,0,7200,1,'MEST'),
(1,1,3600,0,'MET'),
(1,2,7200,1,'MEST'),
(1,3,3600,0,'MET'),
(2,0,0,0,'UTC'),
(3,0,9000,0,'MMT'),
(3,1,12648,1,'MST'),
(3,2,9048,0,'MMT'),
(3,3,16248,1,'MDST'),
(3,4,10800,0,'MSK'),
(3,5,14400,1,'MSD'),
(3,6,18000,1,'MSD'),
(3,7,7200,0,'EET'),
(3,8,10800,0,'MSK'),
(3,9,14400,1,'MSD'),
(3,10,10800,1,'EEST'),
(3,11,7200,0,'EET'),
(4,0,9000,0,'MMT'),
(4,1,12648,1,'MST'),
(4,2,9048,0,'MMT'),
(4,3,16248,1,'MDST'),
(4,4,10800,0,'MSK'),
(4,5,14400,1,'MSD'),
(4,6,18000,1,'MSD'),
(4,7,7200,0,'EET'),
(4,8,10800,0,'MSK'),
(4,9,14400,1,'MSD'),
(4,10,10800,1,'EEST'),
(4,11,7200,0,'EET'),
(5,0,32400,0,'CJT'),
(5,1,32400,0,'JST'),
(6,1,19800,0,'IST');
/*!40000 ALTER TABLE `time_zone_transition_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

#
# mysqldump of system tables with --system=all --insert-ignore
#
/*M!999999\- enable the sandbox mode */

/*!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 utf8mb4 */;
/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
INSTALL PLUGIN `test_plugin_server` /*M!100401 IF NOT EXISTS */ SONAME 'AUTH_TEST_PLUGIN_LIB';
INSTALL PLUGIN `cleartext_plugin_server` /*M!100401 IF NOT EXISTS */ SONAME 'AUTH_TEST_PLUGIN_LIB';
CREATE USER IF NOT EXISTS `mariadb.sys`@`localhost` PASSWORD EXPIRE;
CREATE USER IF NOT EXISTS `root`@`localhost`;
CREATE USER IF NOT EXISTS `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
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;
/*!80001 CREATE ROLE IF NOT EXISTS 'role_1' */;
/*M!100005 CREATE ROLE IF NOT EXISTS 'role_1' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_1' TO 'root'@'localhost' WITH ADMIN OPTION */;
/*!80001 CREATE ROLE IF NOT EXISTS 'role_2' */;
/*M!100005 CREATE ROLE IF NOT EXISTS 'role_2' WITH ADMIN mariadb_dump_import_role */;
/*M!100005 GRANT 'role_2' TO 'role_1' WITH ADMIN OPTION */;
GRANT USAGE ON *.* TO `mariadb.sys`@`localhost`;
GRANT SELECT, DELETE ON `mysql`.`global_priv` TO `mariadb.sys`@`localhost`;
/*M!100005 SET DEFAULT ROLE NONE FOR 'mariadb.sys'@'localhost' */;
/*!80001 ALTER USER 'mariadb.sys'@'localhost' DEFAULT ROLE NONE */;
GRANT `role_1` TO `root`@`localhost` WITH ADMIN OPTION;
GRANT ALL PRIVILEGES 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 `role_1` TO `foobar`@`%`;
GRANT `role_2` TO `foobar`@`%`;
GRANT USAGE ON *.* TO `foobar`@`%` IDENTIFIED VIA test_plugin_server USING 'plug_dest';
/*M!100005 SET DEFAULT ROLE 'role_2' FOR 'foobar'@'%' */;
/*!80001 ALTER USER 'foobar'@'%' DEFAULT ROLE 'role_2' */;
GRANT `role_2` TO `role_1` WITH ADMIN OPTION;
GRANT SHOW DATABASES ON *.* TO `role_1`;
GRANT USAGE ON *.* TO `role_2`;
GRANT USAGE ON *.* TO `role_2`;
SET ROLE NONE;
DROP ROLE mariadb_dump_import_role;
/*M!100203 EXECUTE IMMEDIATE CONCAT('SET ROLE ', @current_role) */;
CREATE FUNCTION IF NOT EXISTS `metaphon` RETURNS STRING SONAME 'UDF_EXAMPLE_LIB';
CREATE AGGREGATE FUNCTION IF NOT EXISTS `avgcost` RETURNS REAL SONAME 'UDF_EXAMPLE_LIB';
CREATE SERVER /*M!100103 IF NOT EXISTS */ `s'2` FOREIGN DATA WRAPPER `my'sql` OPTIONS (`HOST` 'h2', `DATABASE` 'db2', `USER` 'u2');
CREATE SERVER /*M!100103 IF NOT EXISTS */ `s1` FOREIGN DATA WRAPPER `mysql` OPTIONS (`HOST` 'localhost', `DATABASE` 'd''b', `USER` 'o''brien', `PASSWORD` 'pw''d');
CREATE SERVER /*M!100103 IF NOT EXISTS */ `s``3` FOREIGN DATA WRAPPER `mysql` OPTIONS (`host` 'value');

USE mysql;

LOCK TABLES `column_stats` WRITE;
/*!40000 ALTER TABLE `column_stats` DISABLE KEYS */;
INSERT IGNORE INTO `column_stats` VALUES
('test','tz','Time_zone_id','1','6',0.0000,4.0000,78.8000,4,'JSON_HB','{\"target_histogram_size\": 254, \"collected_at\": \"2022-01-07 07:07:00\", \"collected_by\": \"version\", \"histogram_hb\": [{\"start\": \"1\", \"size\": 0.340101523, \"ndv\": 1}, {\"start\": \"3\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"4\", \"size\": 0.327411168, \"ndv\": 1}, {\"start\": \"5\", \"end\": \"6\", \"size\": 0.005076142, \"ndv\": 2}]}');
/*!40000 ALTER TABLE `column_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `index_stats` WRITE;
/*!40000 ALTER TABLE `index_stats` DISABLE KEYS */;
INSERT IGNORE INTO `index_stats` VALUES
('test','tz','PRIMARY',1,78.8000);
/*!40000 ALTER TABLE `index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `table_stats` WRITE;
/*!40000 ALTER TABLE `table_stats` DISABLE KEYS */;
INSERT IGNORE INTO `table_stats` VALUES
('test','tz',394);
/*!40000 ALTER TABLE `table_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_index_stats` WRITE;
/*!40000 ALTER TABLE `innodb_index_stats` DISABLE KEYS */;
INSERT IGNORE INTO `innodb_index_stats` VALUES
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx01',5,1,'Time_zone_id'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_diff_pfx02',394,1,'Time_zone_id,Transition_time'),
('test','tz','PRIMARY','2019-12-31 21:00:00','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),
('test','tz','PRIMARY','2019-12-31 21:00:00','size',1,NULL,'Number of pages in the index');
/*!40000 ALTER TABLE `innodb_index_stats` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `innodb_table_stats` WRITE;
/*!40000 ALTER TABLE `innodb_table_stats` DISABLE KEYS */;
INSERT IGNORE INTO `innodb_table_stats` VALUES
('test','tz','2019-12-31 21:00:00',394,1,0);
/*!40000 ALTER TABLE `innodb_table_stats` ENABLE KEYS */;
UNLOCK TABLES;

USE mysql;

LOCK TABLES `time_zone` WRITE;
/*!40000 ALTER TABLE `time_zone` DISABLE KEYS */;
INSERT IGNORE INTO `time_zone` VALUES
(1,'N'),
(2,'N'),
(3,'N'),
(4,'Y'),
(5,'N'),
(6,'Y');
/*!40000 ALTER TABLE `time_zone` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_name` WRITE;
/*!40000 ALTER TABLE `time_zone_name` DISABLE KEYS */;
INSERT IGNORE INTO `time_zone_name` VALUES
('Europe/Moscow',3),
('India/Kolkata',6),
('Japan',5),
('leap/Europe/Moscow',4),
('MET',1),
('Universal',2),
('UTC',2);
/*!40000 ALTER TABLE `time_zone_name` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_leap_second` WRITE;
/*!40000 ALTER TABLE `time_zone_leap_second` DISABLE KEYS */;
INSERT IGNORE INTO `time_zone_leap_second` VALUES
(174834660,1),
(78796800,1),
(94694401,2),
(126230402,3),
(157766403,4),
(189302404,5),
(220924805,6),
(252460806,7),
(283996807,8),
(315532808,9),
(362793609,10),
(394329610,11),
(425865611,12),
(489024012,13),
(567993613,14),
(631152014,15),
(662688015,16),
(709948816,17),
(741484817,18),
(773020818,19),
(820454419,20),
(867715220,21),
(915148821,22);
/*!40000 ALTER TABLE `time_zone_leap_second` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition` WRITE;
/*!40000 ALTER TABLE `time_zone_transition` DISABLE KEYS */;
INSERT IGNORE INTO `time_zone_transition` VALUES
(1,-1693706400,0),
(1,-1680483600,1),
(1,-1663455600,2),
(1,-1650150000,3),
(1,-1632006000,2),
(1,-1618700400,3),
(1,-938905200,2),
(1,-857257200,3),
(1,-844556400,2),
(1,-828226800,3),
(1,-812502000,2),
(1,-796777200,3),
(1,228877200,2),
(1,243997200,3),
(1,260326800,2),
(1,276051600,3),
(1,291776400,2),
(1,307501200,3),
(1,323830800,2),
(1,338950800,3),
(1,354675600,2),
(1,370400400,3),
(1,386125200,2),
(1,401850000,3),
(1,417574800,2),
(1,433299600,3),
(1,449024400,2),
(1,465354000,3),
(1,481078800,2),
(1,496803600,3),
(1,512528400,2),
(1,528253200,3),
(1,543978000,2),
(1,559702800,3),
(1,575427600,2),
(1,591152400,3),
(1,606877200,2),
(1,622602000,3),
(1,638326800,2),
(1,654656400,3),
(1,670381200,2),
(1,686106000,3),
(1,701830800,2),
(1,717555600,3),
(1,733280400,2),
(1,749005200,3),
(1,764730000,2),
(1,780454800,3),
(1,796179600,2),
(1,811904400,3),
(1,828234000,2),
(1,846378000,3),
(1,859683600,2),
(1,877827600,3),
(1,891133200,2),
(1,909277200,3),
(1,922582800,2),
(1,941331600,3),
(1,954032400,2),
(1,972781200,3),
(1,985482000,2),
(1,1004230800,3),
(1,1017536400,2),
(1,1035680400,3),
(1,1048986000,2),
(1,1067130000,3),
(1,1080435600,2),
(1,1099184400,3),
(1,1111885200,2),
(1,1130634000,3),
(1,1143334800,2),
(1,1162083600,3),
(1,1174784400,2),
(1,1193533200,3),
(1,1206838800,2),
(1,1224982800,3),
(1,1238288400,2),
(1,1256432400,3),
(1,1269738000,2),
(1,1288486800,3),
(1,1301187600,2),
(1,1319936400,3),
(1,1332637200,2),
(1,1351386000,3),
(1,1364691600,2),
(1,1382835600,3),
(1,1396141200,2),
(1,1414285200,3),
(1,1427590800,2),
(1,1445734800,3),
(1,1459040400,2),
(1,1477789200,3),
(1,1490490000,2),
(1,1509238800,3),
(1,1521939600,2),
(1,1540688400,3),
(1,1553994000,2),
(1,1572138000,3),
(1,1585443600,2),
(1,1603587600,3),
(1,1616893200,2),
(1,1635642000,3),
(1,1648342800,2),
(1,1667091600,3),
(1,1679792400,2),
(1,1698541200,3),
(1,1711846800,2),
(1,1729990800,3),
(1,1743296400,2),
(1,1761440400,3),
(1,1774746000,2),
(1,1792890000,3),
(1,1806195600,2),
(1,1824944400,3),
(1,1837645200,2),
(1,1856394000,3),
(1,1869094800,2),
(1,1887843600,3),
(1,1901149200,2),
(1,1919293200,3),
(1,1932598800,2),
(1,1950742800,3),
(1,1964048400,2),
(1,1982797200,3),
(1,1995498000,2),
(1,2014246800,3),
(1,2026947600,2),
(1,2045696400,3),
(1,2058397200,2),
(1,2077146000,3),
(1,2090451600,2),
(1,2108595600,3),
(1,2121901200,2),
(1,2140045200,3),
(3,-1688265000,2),
(3,-1656819048,1),
(3,-1641353448,2),
(3,-1627965048,3),
(3,-1618716648,1),
(3,-1596429048,3),
(3,-1593829848,5),
(3,-1589860800,4),
(3,-1542427200,5),
(3,-1539493200,6),
(3,-1525323600,5),
(3,-1522728000,4),
(3,-1491188400,7),
(3,-1247536800,4),
(3,354920400,5),
(3,370728000,4),
(3,386456400,5),
(3,402264000,4),
(3,417992400,5),
(3,433800000,4),
(3,449614800,5),
(3,465346800,8),
(3,481071600,9),
(3,496796400,8),
(3,512521200,9),
(3,528246000,8),
(3,543970800,9),
(3,559695600,8),
(3,575420400,9),
(3,591145200,8),
(3,606870000,9),
(3,622594800,8),
(3,638319600,9),
(3,654649200,8),
(3,670374000,10),
(3,686102400,11),
(3,695779200,8),
(3,701812800,5),
(3,717534000,4),
(3,733273200,9),
(3,748998000,8),
(3,764722800,9),
(3,780447600,8),
(3,796172400,9),
(3,811897200,8),
(3,828226800,9),
(3,846370800,8),
(3,859676400,9),
(3,877820400,8),
(3,891126000,9),
(3,909270000,8),
(3,922575600,9),
(3,941324400,8),
(3,954025200,9),
(3,972774000,8),
(3,985474800,9),
(3,1004223600,8),
(3,1017529200,9),
(3,1035673200,8),
(3,1048978800,9),
(3,1067122800,8),
(3,1080428400,9),
(3,1099177200,8),
(3,1111878000,9),
(3,1130626800,8),
(3,1143327600,9),
(3,1162076400,8),
(3,1174777200,9),
(3,1193526000,8),
(3,1206831600,9),
(3,1224975600,8),
(3,1238281200,9),
(3,1256425200,8),
(3,1269730800,9),
(3,1288479600,8),
(3,1301180400,9),
(3,1319929200,8),
(3,1332630000,9),
(3,1351378800,8),
(3,1364684400,9),
(3,1382828400,8),
(3,1396134000,9),
(3,1414278000,8),
(3,1427583600,9),
(3,1445727600,8),
(3,1459033200,9),
(3,1477782000,8),
(3,1490482800,9),
(3,1509231600,8),
(3,1521932400,9),
(3,1540681200,8),
(3,1553986800,9),
(3,1572130800,8),
(3,1585436400,9),
(3,1603580400,8),
(3,1616886000,9),
(3,1635634800,8),
(3,1648335600,9),
(3,1667084400,8),
(3,1679785200,9),
(3,1698534000,8),
(3,1711839600,9),
(3,1729983600,8),
(3,1743289200,9),
(3,1761433200,8),
(3,1774738800,9),
(3,1792882800,8),
(3,1806188400,9),
(3,1824937200,8),
(3,1837638000,9),
(3,1856386800,8),
(3,1869087600,9),
(3,1887836400,8),
(3,1901142000,9),
(3,1919286000,8),
(3,1932591600,9),
(3,1950735600,8),
(3,1964041200,9),
(3,1982790000,8),
(3,1995490800,9),
(3,2014239600,8),
(3,2026940400,9),
(3,2045689200,8),
(3,2058390000,9),
(3,2077138800,8),
(3,2090444400,9),
(3,2108588400,8),
(3,2121894000,9),
(3,2140038000,8),
(4,-1688265000,2),
(4,-1656819048,1),
(4,-1641353448,2),
(4,-1627965048,3),
(4,-1618716648,1),
(4,-1596429048,3),
(4,-1593829848,5),
(4,-1589860800,4),
(4,-1542427200,5),
(4,-1539493200,6),
(4,-1525323600,5),
(4,-1522728000,4),
(4,-1491188400,7),
(4,-1247536800,4),
(4,354920409,5),
(4,370728010,4),
(4,386456410,5),
(4,402264011,4),
(4,417992411,5),
(4,433800012,4),
(4,449614812,5),
(4,465346812,8),
(4,481071612,9),
(4,496796413,8),
(4,512521213,9),
(4,528246013,8),
(4,543970813,9),
(4,559695613,8),
(4,575420414,9),
(4,591145214,8),
(4,606870014,9),
(4,622594814,8),
(4,638319615,9),
(4,654649215,8),
(4,670374016,10),
(4,686102416,11),
(4,695779216,8),
(4,701812816,5),
(4,717534017,4),
(4,733273217,9),
(4,748998018,8),
(4,764722818,9),
(4,780447619,8),
(4,796172419,9),
(4,811897219,8),
(4,828226820,9),
(4,846370820,8),
(4,859676420,9),
(4,877820421,8),
(4,891126021,9),
(4,909270021,8),
(4,922575622,9),
(4,941324422,8),
(4,954025222,9),
(4,972774022,8),
(4,985474822,9),
(4,1004223622,8),
(4,1017529222,9),
(4,1035673222,8),
(4,1048978822,9),
(4,1067122822,8),
(4,1080428422,9),
(4,1099177222,8),
(4,1111878022,9),
(4,1130626822,8),
(4,1143327622,9),
(4,1162076422,8),
(4,1174777222,9),
(4,1193526022,8),
(4,1206831622,9),
(4,1224975622,8),
(4,1238281222,9),
(4,1256425222,8),
(4,1269730822,9),
(4,1288479622,8),
(4,1301180422,9),
(4,1319929222,8),
(4,1332630022,9),
(4,1351378822,8),
(4,1364684422,9),
(4,1382828422,8),
(4,1396134022,9),
(4,1414278022,8),
(4,1427583622,9),
(4,1445727622,8),
(4,1459033222,9),
(4,1477782022,8),
(4,1490482822,9),
(4,1509231622,8),
(4,1521932422,9),
(4,1540681222,8),
(4,1553986822,9),
(4,1572130822,8),
(4,1585436422,9),
(4,1603580422,8),
(4,1616886022,9),
(4,1635634822,8),
(4,1648335622,9),
(4,1667084422,8),
(4,1679785222,9),
(4,1698534022,8),
(4,1711839622,9),
(4,1729983622,8),
(4,1743289222,9),
(4,1761433222,8),
(4,1774738822,9),
(4,1792882822,8),
(4,1806188422,9),
(4,1824937222,8),
(4,1837638022,9),
(4,1856386822,8),
(4,1869087622,9),
(4,1887836422,8),
(4,1901142022,9),
(4,1919286022,8),
(4,1932591622,9),
(4,1950735622,8),
(4,1964041222,9),
(4,1982790022,8),
(4,1995490822,9),
(4,2014239622,8),
(4,2026940422,9),
(4,2045689222,8),
(4,2058390022,9),
(4,2077138822,8),
(4,2090444422,9),
(4,2108588422,8),
(4,2121894022,9),
(4,2140038022,8),
(5,-1009875600,1),
(6,174834660,1);
/*!40000 ALTER TABLE `time_zone_transition` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `time_zone_transition_type` WRITE;
/*!40000 ALTER TABLE `time_zone_transition_type` DISABLE KEYS */;
INSERT IGNORE INTO `time_zone_transition_type` VALUES
(1,0,7200,1,'MEST'),
(1,1,3600,0,'MET'),
(1,2,7200,1,'MEST'),
(1,3,3600,0,'MET'),
(2,0,0,0,'UTC'),
(3,0,9000,0,'MMT'),
(3,1,12648,1,'MST'),
(3,2,9048,0,'MMT'),
(3,3,16248,1,'MDST'),
(3,4,10800,0,'MSK'),
(3,5,14400,1,'MSD'),
(3,6,18000,1,'MSD'),
(3,7,7200,0,'EET'),
(3,8,10800,0,'MSK'),
(3,9,14400,1,'MSD'),
(3,10,10800,1,'EEST'),
(3,11,7200,0,'EET'),
(4,0,9000,0,'MMT'),
(4,1,12648,1,'MST'),
(4,2,9048,0,'MMT'),
(4,3,16248,1,'MDST'),
(4,4,10800,0,'MSK'),
(4,5,14400,1,'MSD'),
(4,6,18000,1,'MSD'),
(4,7,7200,0,'EET'),
(4,8,10800,0,'MSK'),
(4,9,14400,1,'MSD'),
(4,10,10800,1,'EEST'),
(4,11,7200,0,'EET'),
(5,0,32400,0,'CJT'),
(5,1,32400,0,'JST'),
(6,1,19800,0,'IST');
/*!40000 ALTER TABLE `time_zone_transition_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

SELECT * FROM mysql.global_priv ORDER BY User,Host;
Host User Priv
% foobar {"access":0,"version_id":VERSION,"plugin":"test_plugin_server","authentication_string":"plug_dest","password_last_changed":NOW,"default_role":"role_2"}
localhost mariadb.sys {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":false,"password_last_changed":NOW,"version_id":VERSION}
role_1 {"access":16384,"version_id":VERSION,"is_role":true}
role_2 {"access":0,"version_id":VERSION,"is_role":true}
localhost root {"access":18446744073709551615}
CHECKSUM TABLE mysql.roles_mapping, mysql.time_zone_transition, mysql.plugin,
mysql.servers, mysql.func, mysql.innodb_table_stats, mysql.table_stats;
Table Checksum
mysql.roles_mapping 2510045525
mysql.time_zone_transition 3719776009
mysql.plugin 1587119305
mysql.servers 3351805004
mysql.func 2140302938
mysql.innodb_table_stats 1972297402
mysql.table_stats 1911089388
# Opps....
CREATE USER mariadb_test_restore IDENTIFIED BY 'getitback';
GRANT ALL ON *.* TO mariadb_test_restore WITH GRANT OPTION;
GRANT PROXY ON ''@'%' TO mariadb_test_restore WITH GRANT OPTION;
GRANT SUPER, CREATE USER /*M!100502 ,FEDERATED ADMIN */ ON *.* TO mariadb_test_restore WITH GRANT OPTION;
drop user foobar;
delete from mysql.table_stats;
delete from mysql.innodb_table_stats;
delete from mysql.time_zone_transition;
delete from mysql.time_zone_transition_type;
delete from mysql.time_zone;
delete from mysql.time_zone_name;
delete from mysql.time_zone_leap_second;
DROP FUNCTION IF EXISTS metaphon;
DROP FUNCTION IF EXISTS avgcost;
DROP SERVER s1;
DROP SERVER `s'2`;
DROP SERVER `s``3`;
set time_zone= @@global.time_zone;
# Restore from mysqldump
DROP USER mariadb_test_restore;
SELECT * FROM mysql.global_priv ORDER BY User,Host;
Host User Priv
% foobar {"access":0,"version_id":VERSION,"plugin":"test_plugin_server","authentication_string":"plug_dest","password_last_changed":NOW,"default_role":"role_2"}
localhost mariadb.sys {"access":0,"version_id":VERSION,"plugin":"mysql_native_password","authentication_string":"","password_last_changed":NOW,"password_lifetime":-1,"default_role":""}
role_1 {"access":16384,"version_id":VERSION,"is_role":true}
role_2 {"access":0,"version_id":VERSION,"is_role":true}
localhost root {"access":1099511627775,"version_id":VERSION,"plugin":"mysql_native_password","authentication_string":"","password_last_changed":NOW,"default_role":""}
CHECKSUM TABLE mysql.roles_mapping, mysql.time_zone_transition, mysql.plugin,
mysql.servers, mysql.func, mysql.innodb_table_stats, mysql.table_stats;
Table Checksum
mysql.roles_mapping 2510045525
mysql.time_zone_transition 3719776009
mysql.plugin 1587119305
mysql.servers 3351805004
mysql.func 2140302938
mysql.innodb_table_stats 1972297402
mysql.table_stats 1911089388
DROP FUNCTION IF EXISTS metaphon;
DROP FUNCTION IF EXISTS avgcost;
DROP SERVER s1;
DROP SERVER `s'2`;
DROP SERVER `s``3`;
DELETE FROM mysql.column_stats WHERE db_name='mysql';
DELETE FROM mysql.index_stats  WHERE db_name='mysql';
DELETE FROM mysql.table_stats  WHERE db_name='mysql';
DELETE FROM mysql.innodb_index_stats WHERE database_name='test';
DELETE FROM mysql.innodb_table_stats WHERE database_name='mysql';
drop table test.tz;
DROP ROLE role_2;
DROP ROLE role_1;
drop user foobar;
replace into mysql.global_priv select * from backup_users;
replace into mysql.tables_priv select * from tables_priv;
flush privileges;
drop table backup_users, tables_priv;
uninstall soname 'auth_test_plugin';

Messung V0.5 in Prozent

¤ Dauer der Verarbeitung: 0.19 Sekunden (vorverarbeitet am 2026-10-08) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.