1
DROP DATABASE IF EXISTS db_datadict;
2
CREATE DATABASE db_datadict;
5
IF(INSTR(table_comment,'InnoDB free') = 0
6
AND INSTR(table_comment,'number_of_replicas') = 0,
8
INSTR(table_comment,'InnoDB free')
9
+ INSTR(table_comment,'number_of_replicas') - 1))
11
'-----------------------------------------------------' AS "Separator"
12
FROM information_schema.tables
13
WHERE table_schema = 'mysql'
14
ORDER BY table_schema,table_name;
17
TABLE_NAME columns_priv
32
TABLE_COLLATION utf8_bin
36
user_comment Column privileges
37
Separator -----------------------------------------------------
55
TABLE_COLLATION utf8_bin
59
user_comment Database privileges
60
Separator -----------------------------------------------------
78
TABLE_COLLATION utf8_general_ci
83
Separator -----------------------------------------------------
101
TABLE_COLLATION utf8_bin
105
user_comment User defined functions
106
Separator -----------------------------------------------------
109
TABLE_NAME general_log
110
TABLE_TYPE BASE TABLE
117
MAX_DATA_LENGTH #MDL#
124
TABLE_COLLATION utf8_general_ci
128
user_comment General log
129
Separator -----------------------------------------------------
132
TABLE_NAME help_category
133
TABLE_TYPE BASE TABLE
140
MAX_DATA_LENGTH #MDL#
147
TABLE_COLLATION utf8_general_ci
151
user_comment help categories
152
Separator -----------------------------------------------------
155
TABLE_NAME help_keyword
156
TABLE_TYPE BASE TABLE
163
MAX_DATA_LENGTH #MDL#
170
TABLE_COLLATION utf8_general_ci
174
user_comment help keywords
175
Separator -----------------------------------------------------
178
TABLE_NAME help_relation
179
TABLE_TYPE BASE TABLE
186
MAX_DATA_LENGTH #MDL#
193
TABLE_COLLATION utf8_general_ci
197
user_comment keyword-topic relation
198
Separator -----------------------------------------------------
201
TABLE_NAME help_topic
202
TABLE_TYPE BASE TABLE
209
MAX_DATA_LENGTH #MDL#
216
TABLE_COLLATION utf8_general_ci
220
user_comment help topics
221
Separator -----------------------------------------------------
225
TABLE_TYPE BASE TABLE
232
MAX_DATA_LENGTH #MDL#
239
TABLE_COLLATION utf8_bin
243
user_comment Host privileges; Merged with database privileges
244
Separator -----------------------------------------------------
247
TABLE_NAME ndb_binlog_index
248
TABLE_TYPE BASE TABLE
255
MAX_DATA_LENGTH #MDL#
262
TABLE_COLLATION latin1_swedish_ci
267
Separator -----------------------------------------------------
270
TABLE_NAME online_backup
271
TABLE_TYPE BASE TABLE
278
MAX_DATA_LENGTH #MDL#
285
TABLE_COLLATION latin1_swedish_ci
290
Separator -----------------------------------------------------
293
TABLE_NAME online_backup_progress
294
TABLE_TYPE BASE TABLE
301
MAX_DATA_LENGTH #MDL#
308
TABLE_COLLATION latin1_swedish_ci
313
Separator -----------------------------------------------------
317
TABLE_TYPE BASE TABLE
324
MAX_DATA_LENGTH #MDL#
331
TABLE_COLLATION utf8_bin
335
user_comment MySQL plugins
336
Separator -----------------------------------------------------
340
TABLE_TYPE BASE TABLE
347
MAX_DATA_LENGTH #MDL#
354
TABLE_COLLATION utf8_general_ci
358
user_comment Stored Procedures
359
Separator -----------------------------------------------------
362
TABLE_NAME procs_priv
363
TABLE_TYPE BASE TABLE
370
MAX_DATA_LENGTH #MDL#
377
TABLE_COLLATION utf8_bin
381
user_comment Procedure privileges
382
Separator -----------------------------------------------------
386
TABLE_TYPE BASE TABLE
393
MAX_DATA_LENGTH #MDL#
400
TABLE_COLLATION utf8_general_ci
404
user_comment MySQL Foreign Servers table
405
Separator -----------------------------------------------------
409
TABLE_TYPE BASE TABLE
416
MAX_DATA_LENGTH #MDL#
423
TABLE_COLLATION utf8_general_ci
427
user_comment Slow log
428
Separator -----------------------------------------------------
431
TABLE_NAME tables_priv
432
TABLE_TYPE BASE TABLE
439
MAX_DATA_LENGTH #MDL#
446
TABLE_COLLATION utf8_bin
450
user_comment Table privileges
451
Separator -----------------------------------------------------
455
TABLE_TYPE BASE TABLE
462
MAX_DATA_LENGTH #MDL#
469
TABLE_COLLATION utf8_general_ci
473
user_comment Time zones
474
Separator -----------------------------------------------------
477
TABLE_NAME time_zone_leap_second
478
TABLE_TYPE BASE TABLE
485
MAX_DATA_LENGTH #MDL#
492
TABLE_COLLATION utf8_general_ci
496
user_comment Leap seconds information for time zones
497
Separator -----------------------------------------------------
500
TABLE_NAME time_zone_name
501
TABLE_TYPE BASE TABLE
508
MAX_DATA_LENGTH #MDL#
515
TABLE_COLLATION utf8_general_ci
519
user_comment Time zone names
520
Separator -----------------------------------------------------
523
TABLE_NAME time_zone_transition
524
TABLE_TYPE BASE TABLE
531
MAX_DATA_LENGTH #MDL#
538
TABLE_COLLATION utf8_general_ci
542
user_comment Time zone transitions
543
Separator -----------------------------------------------------
546
TABLE_NAME time_zone_transition_type
547
TABLE_TYPE BASE TABLE
554
MAX_DATA_LENGTH #MDL#
561
TABLE_COLLATION utf8_general_ci
565
user_comment Time zone transition types
566
Separator -----------------------------------------------------
570
TABLE_TYPE BASE TABLE
577
MAX_DATA_LENGTH #MDL#
584
TABLE_COLLATION utf8_bin
588
user_comment Users and global privileges
589
Separator -----------------------------------------------------
590
DROP USER testuser1@localhost;
591
CREATE USER testuser1@localhost;
592
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
593
# Establish connection testuser1 (user=testuser1)
596
IF(INSTR(table_comment,'InnoDB free') = 0
597
AND INSTR(table_comment,'number_of_replicas') = 0,
598
LENGTH(table_comment),
599
INSTR(table_comment,'InnoDB free')
600
+ INSTR(table_comment,'number_of_replicas') - 1))
602
'-----------------------------------------------------' AS "Separator"
603
FROM information_schema.tables
604
WHERE table_schema = 'mysql'
605
ORDER BY table_schema,table_name;
606
# Switch to connection default and close connection testuser1
607
DROP USER testuser1@localhost;
608
DROP DATABASE db_datadict;