Debian Codegraph @

mysql-test/suite/sysschema/r/mysqldump.result

raw
1 CREATE TEMPORARY TABLE tmp_global_priv AS SELECT * FROM mysql.global_priv;
2 CREATE TEMPORARY TABLE tmp_tables_priv AS SELECT * FROM mysql.tables_priv;
3 DROP DATABASE sys;
4 SHOW DATABASES;
5 Database
6 information_schema
7 mtr
8 mysql
9 performance_schema
10 test
11 SHOW DATABASES;
12 Database
13 information_schema
14 mtr
15 mysql
16 performance_schema
17 sys
18 test
19 TRUNCATE TABLE mysql.global_priv;
20 INSERT INTO mysql.global_priv (SELECT * FROM tmp_global_priv);
21 DROP TEMPORARY TABLE tmp_global_priv;
22 TRUNCATE TABLE mysql.tables_priv;
23 INSERT INTO mysql.tables_priv (SELECT * FROM tmp_tables_priv);
24 DROP TEMPORARY TABLE tmp_tables_priv;
25 FLUSH PRIVILEGES;