1DROP DATABASE IF EXISTS test1;
2CREATE DATABASE test1;
3SELECT *,
4LEFT( table_comment,
5IF(INSTR(table_comment,'InnoDB free') = 0,
6LENGTH(table_comment),
7INSTR(table_comment,'InnoDB free') - 1))
8AS "user_comment",
9'-----------------------------------------------------' AS "Separator"
10FROM information_schema.tables
11WHERE table_schema = 'mysql'
12ORDER BY table_schema,table_name;
13TABLE_CATALOG	def
14TABLE_SCHEMA	mysql
15TABLE_NAME	columns_priv
16TABLE_TYPE	BASE TABLE
17ENGINE	MYISAM_OR_MARIA
18VERSION	10
19ROW_FORMAT	Fixed
20TABLE_ROWS	#TBLR#
21AVG_ROW_LENGTH	#ARL#
22DATA_LENGTH	#DL#
23MAX_DATA_LENGTH	#MDL#
24INDEX_LENGTH	#IL#
25DATA_FREE	#DF#
26AUTO_INCREMENT	NULL
27CREATE_TIME	#CRT#
28UPDATE_TIME	#UT#
29CHECK_TIME	#CT#
30TABLE_COLLATION	utf8_bin
31CHECKSUM	NULL
32CREATE_OPTIONS	#CO#
33TABLE_COMMENT	#TC#
34MAX_INDEX_LENGTH	#MIL#
35TEMPORARY	N
36user_comment	Column privileges
37Separator	-----------------------------------------------------
38TABLE_CATALOG	def
39TABLE_SCHEMA	mysql
40TABLE_NAME	column_stats
41TABLE_TYPE	BASE TABLE
42ENGINE	MYISAM_OR_MARIA
43VERSION	10
44ROW_FORMAT	DYNAMIC_OR_PAGE
45TABLE_ROWS	#TBLR#
46AVG_ROW_LENGTH	#ARL#
47DATA_LENGTH	#DL#
48MAX_DATA_LENGTH	#MDL#
49INDEX_LENGTH	#IL#
50DATA_FREE	#DF#
51AUTO_INCREMENT	NULL
52CREATE_TIME	#CRT#
53UPDATE_TIME	#UT#
54CHECK_TIME	#CT#
55TABLE_COLLATION	utf8_bin
56CHECKSUM	NULL
57CREATE_OPTIONS	#CO#
58TABLE_COMMENT	#TC#
59MAX_INDEX_LENGTH	#MIL#
60TEMPORARY	N
61user_comment	Statistics on Columns
62Separator	-----------------------------------------------------
63TABLE_CATALOG	def
64TABLE_SCHEMA	mysql
65TABLE_NAME	db
66TABLE_TYPE	BASE TABLE
67ENGINE	MYISAM_OR_MARIA
68VERSION	10
69ROW_FORMAT	Fixed
70TABLE_ROWS	#TBLR#
71AVG_ROW_LENGTH	#ARL#
72DATA_LENGTH	#DL#
73MAX_DATA_LENGTH	#MDL#
74INDEX_LENGTH	#IL#
75DATA_FREE	#DF#
76AUTO_INCREMENT	NULL
77CREATE_TIME	#CRT#
78UPDATE_TIME	#UT#
79CHECK_TIME	#CT#
80TABLE_COLLATION	utf8_bin
81CHECKSUM	NULL
82CREATE_OPTIONS	#CO#
83TABLE_COMMENT	#TC#
84MAX_INDEX_LENGTH	#MIL#
85TEMPORARY	N
86user_comment	Database privileges
87Separator	-----------------------------------------------------
88TABLE_CATALOG	def
89TABLE_SCHEMA	mysql
90TABLE_NAME	event
91TABLE_TYPE	BASE TABLE
92ENGINE	MYISAM_OR_MARIA
93VERSION	10
94ROW_FORMAT	DYNAMIC_OR_PAGE
95TABLE_ROWS	#TBLR#
96AVG_ROW_LENGTH	#ARL#
97DATA_LENGTH	#DL#
98MAX_DATA_LENGTH	#MDL#
99INDEX_LENGTH	#IL#
100DATA_FREE	#DF#
101AUTO_INCREMENT	NULL
102CREATE_TIME	#CRT#
103UPDATE_TIME	#UT#
104CHECK_TIME	#CT#
105TABLE_COLLATION	utf8_general_ci
106CHECKSUM	NULL
107CREATE_OPTIONS	#CO#
108TABLE_COMMENT	#TC#
109MAX_INDEX_LENGTH	#MIL#
110TEMPORARY	N
111user_comment	Events
112Separator	-----------------------------------------------------
113TABLE_CATALOG	def
114TABLE_SCHEMA	mysql
115TABLE_NAME	func
116TABLE_TYPE	BASE TABLE
117ENGINE	MYISAM_OR_MARIA
118VERSION	10
119ROW_FORMAT	Fixed
120TABLE_ROWS	#TBLR#
121AVG_ROW_LENGTH	#ARL#
122DATA_LENGTH	#DL#
123MAX_DATA_LENGTH	#MDL#
124INDEX_LENGTH	#IL#
125DATA_FREE	#DF#
126AUTO_INCREMENT	NULL
127CREATE_TIME	#CRT#
128UPDATE_TIME	#UT#
129CHECK_TIME	#CT#
130TABLE_COLLATION	utf8_bin
131CHECKSUM	NULL
132CREATE_OPTIONS	#CO#
133TABLE_COMMENT	#TC#
134MAX_INDEX_LENGTH	#MIL#
135TEMPORARY	N
136user_comment	User defined functions
137Separator	-----------------------------------------------------
138TABLE_CATALOG	def
139TABLE_SCHEMA	mysql
140TABLE_NAME	general_log
141TABLE_TYPE	BASE TABLE
142ENGINE	CSV
143VERSION	10
144ROW_FORMAT	DYNAMIC_OR_PAGE
145TABLE_ROWS	#TBLR#
146AVG_ROW_LENGTH	#ARL#
147DATA_LENGTH	#DL#
148MAX_DATA_LENGTH	#MDL#
149INDEX_LENGTH	#IL#
150DATA_FREE	#DF#
151AUTO_INCREMENT	NULL
152CREATE_TIME	#CRT#
153UPDATE_TIME	#UT#
154CHECK_TIME	#CT#
155TABLE_COLLATION	utf8_general_ci
156CHECKSUM	NULL
157CREATE_OPTIONS	#CO#
158TABLE_COMMENT	#TC#
159MAX_INDEX_LENGTH	#MIL#
160TEMPORARY	N
161user_comment	General log
162Separator	-----------------------------------------------------
163TABLE_CATALOG	def
164TABLE_SCHEMA	mysql
165TABLE_NAME	gtid_slave_pos
166TABLE_TYPE	BASE TABLE
167ENGINE	MYISAM_OR_MARIA
168VERSION	10
169ROW_FORMAT	Fixed
170TABLE_ROWS	#TBLR#
171AVG_ROW_LENGTH	#ARL#
172DATA_LENGTH	#DL#
173MAX_DATA_LENGTH	#MDL#
174INDEX_LENGTH	#IL#
175DATA_FREE	#DF#
176AUTO_INCREMENT	NULL
177CREATE_TIME	#CRT#
178UPDATE_TIME	#UT#
179CHECK_TIME	#CT#
180TABLE_COLLATION	latin1_swedish_ci
181CHECKSUM	NULL
182CREATE_OPTIONS	#CO#
183TABLE_COMMENT	#TC#
184MAX_INDEX_LENGTH	#MIL#
185TEMPORARY	N
186user_comment	Replication slave GTID position
187Separator	-----------------------------------------------------
188TABLE_CATALOG	def
189TABLE_SCHEMA	mysql
190TABLE_NAME	help_category
191TABLE_TYPE	BASE TABLE
192ENGINE	MYISAM_OR_MARIA
193VERSION	10
194ROW_FORMAT	DYNAMIC_OR_PAGE
195TABLE_ROWS	#TBLR#
196AVG_ROW_LENGTH	#ARL#
197DATA_LENGTH	#DL#
198MAX_DATA_LENGTH	#MDL#
199INDEX_LENGTH	#IL#
200DATA_FREE	#DF#
201AUTO_INCREMENT	NULL
202CREATE_TIME	#CRT#
203UPDATE_TIME	#UT#
204CHECK_TIME	#CT#
205TABLE_COLLATION	utf8_general_ci
206CHECKSUM	NULL
207CREATE_OPTIONS	#CO#
208TABLE_COMMENT	#TC#
209MAX_INDEX_LENGTH	#MIL#
210TEMPORARY	N
211user_comment	help categories
212Separator	-----------------------------------------------------
213TABLE_CATALOG	def
214TABLE_SCHEMA	mysql
215TABLE_NAME	help_keyword
216TABLE_TYPE	BASE TABLE
217ENGINE	MYISAM_OR_MARIA
218VERSION	10
219ROW_FORMAT	Fixed
220TABLE_ROWS	#TBLR#
221AVG_ROW_LENGTH	#ARL#
222DATA_LENGTH	#DL#
223MAX_DATA_LENGTH	#MDL#
224INDEX_LENGTH	#IL#
225DATA_FREE	#DF#
226AUTO_INCREMENT	NULL
227CREATE_TIME	#CRT#
228UPDATE_TIME	#UT#
229CHECK_TIME	#CT#
230TABLE_COLLATION	utf8_general_ci
231CHECKSUM	NULL
232CREATE_OPTIONS	#CO#
233TABLE_COMMENT	#TC#
234MAX_INDEX_LENGTH	#MIL#
235TEMPORARY	N
236user_comment	help keywords
237Separator	-----------------------------------------------------
238TABLE_CATALOG	def
239TABLE_SCHEMA	mysql
240TABLE_NAME	help_relation
241TABLE_TYPE	BASE TABLE
242ENGINE	MYISAM_OR_MARIA
243VERSION	10
244ROW_FORMAT	Fixed
245TABLE_ROWS	#TBLR#
246AVG_ROW_LENGTH	#ARL#
247DATA_LENGTH	#DL#
248MAX_DATA_LENGTH	#MDL#
249INDEX_LENGTH	#IL#
250DATA_FREE	#DF#
251AUTO_INCREMENT	NULL
252CREATE_TIME	#CRT#
253UPDATE_TIME	#UT#
254CHECK_TIME	#CT#
255TABLE_COLLATION	utf8_general_ci
256CHECKSUM	NULL
257CREATE_OPTIONS	#CO#
258TABLE_COMMENT	#TC#
259MAX_INDEX_LENGTH	#MIL#
260TEMPORARY	N
261user_comment	keyword-topic relation
262Separator	-----------------------------------------------------
263TABLE_CATALOG	def
264TABLE_SCHEMA	mysql
265TABLE_NAME	help_topic
266TABLE_TYPE	BASE TABLE
267ENGINE	MYISAM_OR_MARIA
268VERSION	10
269ROW_FORMAT	DYNAMIC_OR_PAGE
270TABLE_ROWS	#TBLR#
271AVG_ROW_LENGTH	#ARL#
272DATA_LENGTH	#DL#
273MAX_DATA_LENGTH	#MDL#
274INDEX_LENGTH	#IL#
275DATA_FREE	#DF#
276AUTO_INCREMENT	NULL
277CREATE_TIME	#CRT#
278UPDATE_TIME	#UT#
279CHECK_TIME	#CT#
280TABLE_COLLATION	utf8_general_ci
281CHECKSUM	NULL
282CREATE_OPTIONS	#CO#
283TABLE_COMMENT	#TC#
284MAX_INDEX_LENGTH	#MIL#
285TEMPORARY	N
286user_comment	help topics
287Separator	-----------------------------------------------------
288TABLE_CATALOG	def
289TABLE_SCHEMA	mysql
290TABLE_NAME	host
291TABLE_TYPE	BASE TABLE
292ENGINE	MYISAM_OR_MARIA
293VERSION	10
294ROW_FORMAT	Fixed
295TABLE_ROWS	#TBLR#
296AVG_ROW_LENGTH	#ARL#
297DATA_LENGTH	#DL#
298MAX_DATA_LENGTH	#MDL#
299INDEX_LENGTH	#IL#
300DATA_FREE	#DF#
301AUTO_INCREMENT	NULL
302CREATE_TIME	#CRT#
303UPDATE_TIME	#UT#
304CHECK_TIME	#CT#
305TABLE_COLLATION	utf8_bin
306CHECKSUM	NULL
307CREATE_OPTIONS	#CO#
308TABLE_COMMENT	#TC#
309MAX_INDEX_LENGTH	#MIL#
310TEMPORARY	N
311user_comment	Host privileges;  Merged with database privileges
312Separator	-----------------------------------------------------
313TABLE_CATALOG	def
314TABLE_SCHEMA	mysql
315TABLE_NAME	index_stats
316TABLE_TYPE	BASE TABLE
317ENGINE	MYISAM_OR_MARIA
318VERSION	10
319ROW_FORMAT	DYNAMIC_OR_PAGE
320TABLE_ROWS	#TBLR#
321AVG_ROW_LENGTH	#ARL#
322DATA_LENGTH	#DL#
323MAX_DATA_LENGTH	#MDL#
324INDEX_LENGTH	#IL#
325DATA_FREE	#DF#
326AUTO_INCREMENT	NULL
327CREATE_TIME	#CRT#
328UPDATE_TIME	#UT#
329CHECK_TIME	#CT#
330TABLE_COLLATION	utf8_bin
331CHECKSUM	NULL
332CREATE_OPTIONS	#CO#
333TABLE_COMMENT	#TC#
334MAX_INDEX_LENGTH	#MIL#
335TEMPORARY	N
336user_comment	Statistics on Indexes
337Separator	-----------------------------------------------------
338TABLE_CATALOG	def
339TABLE_SCHEMA	mysql
340TABLE_NAME	innodb_index_stats
341TABLE_TYPE	BASE TABLE
342ENGINE	InnoDB
343VERSION	10
344ROW_FORMAT	DYNAMIC_OR_PAGE
345TABLE_ROWS	#TBLR#
346AVG_ROW_LENGTH	#ARL#
347DATA_LENGTH	#DL#
348MAX_DATA_LENGTH	#MDL#
349INDEX_LENGTH	#IL#
350DATA_FREE	#DF#
351AUTO_INCREMENT	NULL
352CREATE_TIME	#CRT#
353UPDATE_TIME	#UT#
354CHECK_TIME	#CT#
355TABLE_COLLATION	utf8_bin
356CHECKSUM	NULL
357CREATE_OPTIONS	#CO#
358TABLE_COMMENT	#TC#
359MAX_INDEX_LENGTH	#MIL#
360TEMPORARY	N
361user_comment
362Separator	-----------------------------------------------------
363TABLE_CATALOG	def
364TABLE_SCHEMA	mysql
365TABLE_NAME	innodb_table_stats
366TABLE_TYPE	BASE TABLE
367ENGINE	InnoDB
368VERSION	10
369ROW_FORMAT	DYNAMIC_OR_PAGE
370TABLE_ROWS	#TBLR#
371AVG_ROW_LENGTH	#ARL#
372DATA_LENGTH	#DL#
373MAX_DATA_LENGTH	#MDL#
374INDEX_LENGTH	#IL#
375DATA_FREE	#DF#
376AUTO_INCREMENT	NULL
377CREATE_TIME	#CRT#
378UPDATE_TIME	#UT#
379CHECK_TIME	#CT#
380TABLE_COLLATION	utf8_bin
381CHECKSUM	NULL
382CREATE_OPTIONS	#CO#
383TABLE_COMMENT	#TC#
384MAX_INDEX_LENGTH	#MIL#
385TEMPORARY	N
386user_comment
387Separator	-----------------------------------------------------
388TABLE_CATALOG	def
389TABLE_SCHEMA	mysql
390TABLE_NAME	plugin
391TABLE_TYPE	BASE TABLE
392ENGINE	MYISAM_OR_MARIA
393VERSION	10
394ROW_FORMAT	DYNAMIC_OR_PAGE
395TABLE_ROWS	#TBLR#
396AVG_ROW_LENGTH	#ARL#
397DATA_LENGTH	#DL#
398MAX_DATA_LENGTH	#MDL#
399INDEX_LENGTH	#IL#
400DATA_FREE	#DF#
401AUTO_INCREMENT	NULL
402CREATE_TIME	#CRT#
403UPDATE_TIME	#UT#
404CHECK_TIME	#CT#
405TABLE_COLLATION	utf8_general_ci
406CHECKSUM	NULL
407CREATE_OPTIONS	#CO#
408TABLE_COMMENT	#TC#
409MAX_INDEX_LENGTH	#MIL#
410TEMPORARY	N
411user_comment	MySQL plugins
412Separator	-----------------------------------------------------
413TABLE_CATALOG	def
414TABLE_SCHEMA	mysql
415TABLE_NAME	proc
416TABLE_TYPE	BASE TABLE
417ENGINE	MYISAM_OR_MARIA
418VERSION	10
419ROW_FORMAT	DYNAMIC_OR_PAGE
420TABLE_ROWS	#TBLR#
421AVG_ROW_LENGTH	#ARL#
422DATA_LENGTH	#DL#
423MAX_DATA_LENGTH	#MDL#
424INDEX_LENGTH	#IL#
425DATA_FREE	#DF#
426AUTO_INCREMENT	NULL
427CREATE_TIME	#CRT#
428UPDATE_TIME	#UT#
429CHECK_TIME	#CT#
430TABLE_COLLATION	utf8_general_ci
431CHECKSUM	NULL
432CREATE_OPTIONS	#CO#
433TABLE_COMMENT	#TC#
434MAX_INDEX_LENGTH	#MIL#
435TEMPORARY	N
436user_comment	Stored Procedures
437Separator	-----------------------------------------------------
438TABLE_CATALOG	def
439TABLE_SCHEMA	mysql
440TABLE_NAME	procs_priv
441TABLE_TYPE	BASE TABLE
442ENGINE	MYISAM_OR_MARIA
443VERSION	10
444ROW_FORMAT	Fixed
445TABLE_ROWS	#TBLR#
446AVG_ROW_LENGTH	#ARL#
447DATA_LENGTH	#DL#
448MAX_DATA_LENGTH	#MDL#
449INDEX_LENGTH	#IL#
450DATA_FREE	#DF#
451AUTO_INCREMENT	NULL
452CREATE_TIME	#CRT#
453UPDATE_TIME	#UT#
454CHECK_TIME	#CT#
455TABLE_COLLATION	utf8_bin
456CHECKSUM	NULL
457CREATE_OPTIONS	#CO#
458TABLE_COMMENT	#TC#
459MAX_INDEX_LENGTH	#MIL#
460TEMPORARY	N
461user_comment	Procedure privileges
462Separator	-----------------------------------------------------
463TABLE_CATALOG	def
464TABLE_SCHEMA	mysql
465TABLE_NAME	proxies_priv
466TABLE_TYPE	BASE TABLE
467ENGINE	MYISAM_OR_MARIA
468VERSION	10
469ROW_FORMAT	Fixed
470TABLE_ROWS	#TBLR#
471AVG_ROW_LENGTH	#ARL#
472DATA_LENGTH	#DL#
473MAX_DATA_LENGTH	#MDL#
474INDEX_LENGTH	#IL#
475DATA_FREE	#DF#
476AUTO_INCREMENT	NULL
477CREATE_TIME	#CRT#
478UPDATE_TIME	#UT#
479CHECK_TIME	#CT#
480TABLE_COLLATION	utf8_bin
481CHECKSUM	NULL
482CREATE_OPTIONS	#CO#
483TABLE_COMMENT	#TC#
484MAX_INDEX_LENGTH	#MIL#
485TEMPORARY	N
486user_comment	User proxy privileges
487Separator	-----------------------------------------------------
488TABLE_CATALOG	def
489TABLE_SCHEMA	mysql
490TABLE_NAME	roles_mapping
491TABLE_TYPE	BASE TABLE
492ENGINE	MYISAM_OR_MARIA
493VERSION	10
494ROW_FORMAT	Fixed
495TABLE_ROWS	#TBLR#
496AVG_ROW_LENGTH	#ARL#
497DATA_LENGTH	#DL#
498MAX_DATA_LENGTH	#MDL#
499INDEX_LENGTH	#IL#
500DATA_FREE	#DF#
501AUTO_INCREMENT	NULL
502CREATE_TIME	#CRT#
503UPDATE_TIME	#UT#
504CHECK_TIME	#CT#
505TABLE_COLLATION	utf8_bin
506CHECKSUM	NULL
507CREATE_OPTIONS	#CO#
508TABLE_COMMENT	#TC#
509MAX_INDEX_LENGTH	#MIL#
510TEMPORARY	N
511user_comment	Granted roles
512Separator	-----------------------------------------------------
513TABLE_CATALOG	def
514TABLE_SCHEMA	mysql
515TABLE_NAME	servers
516TABLE_TYPE	BASE TABLE
517ENGINE	MYISAM_OR_MARIA
518VERSION	10
519ROW_FORMAT	DYNAMIC_OR_PAGE
520TABLE_ROWS	#TBLR#
521AVG_ROW_LENGTH	#ARL#
522DATA_LENGTH	#DL#
523MAX_DATA_LENGTH	#MDL#
524INDEX_LENGTH	#IL#
525DATA_FREE	#DF#
526AUTO_INCREMENT	NULL
527CREATE_TIME	#CRT#
528UPDATE_TIME	#UT#
529CHECK_TIME	#CT#
530TABLE_COLLATION	utf8_general_ci
531CHECKSUM	NULL
532CREATE_OPTIONS	#CO#
533TABLE_COMMENT	#TC#
534MAX_INDEX_LENGTH	#MIL#
535TEMPORARY	N
536user_comment	MySQL Foreign Servers table
537Separator	-----------------------------------------------------
538TABLE_CATALOG	def
539TABLE_SCHEMA	mysql
540TABLE_NAME	slow_log
541TABLE_TYPE	BASE TABLE
542ENGINE	CSV
543VERSION	10
544ROW_FORMAT	DYNAMIC_OR_PAGE
545TABLE_ROWS	#TBLR#
546AVG_ROW_LENGTH	#ARL#
547DATA_LENGTH	#DL#
548MAX_DATA_LENGTH	#MDL#
549INDEX_LENGTH	#IL#
550DATA_FREE	#DF#
551AUTO_INCREMENT	NULL
552CREATE_TIME	#CRT#
553UPDATE_TIME	#UT#
554CHECK_TIME	#CT#
555TABLE_COLLATION	utf8_general_ci
556CHECKSUM	NULL
557CREATE_OPTIONS	#CO#
558TABLE_COMMENT	#TC#
559MAX_INDEX_LENGTH	#MIL#
560TEMPORARY	N
561user_comment	Slow log
562Separator	-----------------------------------------------------
563TABLE_CATALOG	def
564TABLE_SCHEMA	mysql
565TABLE_NAME	tables_priv
566TABLE_TYPE	BASE TABLE
567ENGINE	MYISAM_OR_MARIA
568VERSION	10
569ROW_FORMAT	Fixed
570TABLE_ROWS	#TBLR#
571AVG_ROW_LENGTH	#ARL#
572DATA_LENGTH	#DL#
573MAX_DATA_LENGTH	#MDL#
574INDEX_LENGTH	#IL#
575DATA_FREE	#DF#
576AUTO_INCREMENT	NULL
577CREATE_TIME	#CRT#
578UPDATE_TIME	#UT#
579CHECK_TIME	#CT#
580TABLE_COLLATION	utf8_bin
581CHECKSUM	NULL
582CREATE_OPTIONS	#CO#
583TABLE_COMMENT	#TC#
584MAX_INDEX_LENGTH	#MIL#
585TEMPORARY	N
586user_comment	Table privileges
587Separator	-----------------------------------------------------
588TABLE_CATALOG	def
589TABLE_SCHEMA	mysql
590TABLE_NAME	table_stats
591TABLE_TYPE	BASE TABLE
592ENGINE	MYISAM_OR_MARIA
593VERSION	10
594ROW_FORMAT	DYNAMIC_OR_PAGE
595TABLE_ROWS	#TBLR#
596AVG_ROW_LENGTH	#ARL#
597DATA_LENGTH	#DL#
598MAX_DATA_LENGTH	#MDL#
599INDEX_LENGTH	#IL#
600DATA_FREE	#DF#
601AUTO_INCREMENT	NULL
602CREATE_TIME	#CRT#
603UPDATE_TIME	#UT#
604CHECK_TIME	#CT#
605TABLE_COLLATION	utf8_bin
606CHECKSUM	NULL
607CREATE_OPTIONS	#CO#
608TABLE_COMMENT	#TC#
609MAX_INDEX_LENGTH	#MIL#
610TEMPORARY	N
611user_comment	Statistics on Tables
612Separator	-----------------------------------------------------
613TABLE_CATALOG	def
614TABLE_SCHEMA	mysql
615TABLE_NAME	time_zone
616TABLE_TYPE	BASE TABLE
617ENGINE	MYISAM_OR_MARIA
618VERSION	10
619ROW_FORMAT	Fixed
620TABLE_ROWS	#TBLR#
621AVG_ROW_LENGTH	#ARL#
622DATA_LENGTH	#DL#
623MAX_DATA_LENGTH	#MDL#
624INDEX_LENGTH	#IL#
625DATA_FREE	#DF#
626AUTO_INCREMENT	6
627CREATE_TIME	#CRT#
628UPDATE_TIME	#UT#
629CHECK_TIME	#CT#
630TABLE_COLLATION	utf8_general_ci
631CHECKSUM	NULL
632CREATE_OPTIONS	#CO#
633TABLE_COMMENT	#TC#
634MAX_INDEX_LENGTH	#MIL#
635TEMPORARY	N
636user_comment	Time zones
637Separator	-----------------------------------------------------
638TABLE_CATALOG	def
639TABLE_SCHEMA	mysql
640TABLE_NAME	time_zone_leap_second
641TABLE_TYPE	BASE TABLE
642ENGINE	MYISAM_OR_MARIA
643VERSION	10
644ROW_FORMAT	Fixed
645TABLE_ROWS	#TBLR#
646AVG_ROW_LENGTH	#ARL#
647DATA_LENGTH	#DL#
648MAX_DATA_LENGTH	#MDL#
649INDEX_LENGTH	#IL#
650DATA_FREE	#DF#
651AUTO_INCREMENT	NULL
652CREATE_TIME	#CRT#
653UPDATE_TIME	#UT#
654CHECK_TIME	#CT#
655TABLE_COLLATION	utf8_general_ci
656CHECKSUM	NULL
657CREATE_OPTIONS	#CO#
658TABLE_COMMENT	#TC#
659MAX_INDEX_LENGTH	#MIL#
660TEMPORARY	N
661user_comment	Leap seconds information for time zones
662Separator	-----------------------------------------------------
663TABLE_CATALOG	def
664TABLE_SCHEMA	mysql
665TABLE_NAME	time_zone_name
666TABLE_TYPE	BASE TABLE
667ENGINE	MYISAM_OR_MARIA
668VERSION	10
669ROW_FORMAT	Fixed
670TABLE_ROWS	#TBLR#
671AVG_ROW_LENGTH	#ARL#
672DATA_LENGTH	#DL#
673MAX_DATA_LENGTH	#MDL#
674INDEX_LENGTH	#IL#
675DATA_FREE	#DF#
676AUTO_INCREMENT	NULL
677CREATE_TIME	#CRT#
678UPDATE_TIME	#UT#
679CHECK_TIME	#CT#
680TABLE_COLLATION	utf8_general_ci
681CHECKSUM	NULL
682CREATE_OPTIONS	#CO#
683TABLE_COMMENT	#TC#
684MAX_INDEX_LENGTH	#MIL#
685TEMPORARY	N
686user_comment	Time zone names
687Separator	-----------------------------------------------------
688TABLE_CATALOG	def
689TABLE_SCHEMA	mysql
690TABLE_NAME	time_zone_transition
691TABLE_TYPE	BASE TABLE
692ENGINE	MYISAM_OR_MARIA
693VERSION	10
694ROW_FORMAT	Fixed
695TABLE_ROWS	#TBLR#
696AVG_ROW_LENGTH	#ARL#
697DATA_LENGTH	#DL#
698MAX_DATA_LENGTH	#MDL#
699INDEX_LENGTH	#IL#
700DATA_FREE	#DF#
701AUTO_INCREMENT	NULL
702CREATE_TIME	#CRT#
703UPDATE_TIME	#UT#
704CHECK_TIME	#CT#
705TABLE_COLLATION	utf8_general_ci
706CHECKSUM	NULL
707CREATE_OPTIONS	#CO#
708TABLE_COMMENT	#TC#
709MAX_INDEX_LENGTH	#MIL#
710TEMPORARY	N
711user_comment	Time zone transitions
712Separator	-----------------------------------------------------
713TABLE_CATALOG	def
714TABLE_SCHEMA	mysql
715TABLE_NAME	time_zone_transition_type
716TABLE_TYPE	BASE TABLE
717ENGINE	MYISAM_OR_MARIA
718VERSION	10
719ROW_FORMAT	Fixed
720TABLE_ROWS	#TBLR#
721AVG_ROW_LENGTH	#ARL#
722DATA_LENGTH	#DL#
723MAX_DATA_LENGTH	#MDL#
724INDEX_LENGTH	#IL#
725DATA_FREE	#DF#
726AUTO_INCREMENT	NULL
727CREATE_TIME	#CRT#
728UPDATE_TIME	#UT#
729CHECK_TIME	#CT#
730TABLE_COLLATION	utf8_general_ci
731CHECKSUM	NULL
732CREATE_OPTIONS	#CO#
733TABLE_COMMENT	#TC#
734MAX_INDEX_LENGTH	#MIL#
735TEMPORARY	N
736user_comment	Time zone transition types
737Separator	-----------------------------------------------------
738TABLE_CATALOG	def
739TABLE_SCHEMA	mysql
740TABLE_NAME	transaction_registry
741TABLE_TYPE	BASE TABLE
742ENGINE	InnoDB
743VERSION	10
744ROW_FORMAT	DYNAMIC_OR_PAGE
745TABLE_ROWS	#TBLR#
746AVG_ROW_LENGTH	#ARL#
747DATA_LENGTH	#DL#
748MAX_DATA_LENGTH	#MDL#
749INDEX_LENGTH	#IL#
750DATA_FREE	#DF#
751AUTO_INCREMENT	NULL
752CREATE_TIME	#CRT#
753UPDATE_TIME	#UT#
754CHECK_TIME	#CT#
755TABLE_COLLATION	utf8_bin
756CHECKSUM	NULL
757CREATE_OPTIONS	#CO#
758TABLE_COMMENT	#TC#
759MAX_INDEX_LENGTH	#MIL#
760TEMPORARY	N
761user_comment
762Separator	-----------------------------------------------------
763TABLE_CATALOG	def
764TABLE_SCHEMA	mysql
765TABLE_NAME	user
766TABLE_TYPE	BASE TABLE
767ENGINE	MYISAM_OR_MARIA
768VERSION	10
769ROW_FORMAT	DYNAMIC_OR_PAGE
770TABLE_ROWS	#TBLR#
771AVG_ROW_LENGTH	#ARL#
772DATA_LENGTH	#DL#
773MAX_DATA_LENGTH	#MDL#
774INDEX_LENGTH	#IL#
775DATA_FREE	#DF#
776AUTO_INCREMENT	NULL
777CREATE_TIME	#CRT#
778UPDATE_TIME	#UT#
779CHECK_TIME	#CT#
780TABLE_COLLATION	utf8_bin
781CHECKSUM	NULL
782CREATE_OPTIONS	#CO#
783TABLE_COMMENT	#TC#
784MAX_INDEX_LENGTH	#MIL#
785TEMPORARY	N
786user_comment	Users and global privileges
787Separator	-----------------------------------------------------
788DROP   USER testuser1@localhost;
789CREATE USER testuser1@localhost;
790GRANT SELECT ON test1.* TO testuser1@localhost;
791connect  testuser1,localhost,testuser1,,test1;
792SELECT *,
793LEFT( table_comment,
794IF(INSTR(table_comment,'InnoDB free') = 0,
795LENGTH(table_comment),
796INSTR(table_comment,'InnoDB free') - 1))
797AS "user_comment",
798'-----------------------------------------------------' AS "Separator"
799FROM information_schema.tables
800WHERE table_schema = 'mysql'
801ORDER BY table_schema,table_name;
802TABLE_CATALOG	def
803TABLE_SCHEMA	mysql
804TABLE_NAME	columns_priv
805TABLE_TYPE	BASE TABLE
806ENGINE	MYISAM_OR_MARIA
807VERSION	10
808ROW_FORMAT	Fixed
809TABLE_ROWS	#TBLR#
810AVG_ROW_LENGTH	#ARL#
811DATA_LENGTH	#DL#
812MAX_DATA_LENGTH	#MDL#
813INDEX_LENGTH	#IL#
814DATA_FREE	#DF#
815AUTO_INCREMENT	NULL
816CREATE_TIME	#CRT#
817UPDATE_TIME	#UT#
818CHECK_TIME	#CT#
819TABLE_COLLATION	utf8_bin
820CHECKSUM	NULL
821CREATE_OPTIONS	#CO#
822TABLE_COMMENT	#TC#
823MAX_INDEX_LENGTH	#MIL#
824TEMPORARY	N
825user_comment	Column privileges
826Separator	-----------------------------------------------------
827TABLE_CATALOG	def
828TABLE_SCHEMA	mysql
829TABLE_NAME	column_stats
830TABLE_TYPE	BASE TABLE
831ENGINE	MYISAM_OR_MARIA
832VERSION	10
833ROW_FORMAT	DYNAMIC_OR_PAGE
834TABLE_ROWS	#TBLR#
835AVG_ROW_LENGTH	#ARL#
836DATA_LENGTH	#DL#
837MAX_DATA_LENGTH	#MDL#
838INDEX_LENGTH	#IL#
839DATA_FREE	#DF#
840AUTO_INCREMENT	NULL
841CREATE_TIME	#CRT#
842UPDATE_TIME	#UT#
843CHECK_TIME	#CT#
844TABLE_COLLATION	utf8_bin
845CHECKSUM	NULL
846CREATE_OPTIONS	#CO#
847TABLE_COMMENT	#TC#
848MAX_INDEX_LENGTH	#MIL#
849TEMPORARY	N
850user_comment	Statistics on Columns
851Separator	-----------------------------------------------------
852TABLE_CATALOG	def
853TABLE_SCHEMA	mysql
854TABLE_NAME	db
855TABLE_TYPE	BASE TABLE
856ENGINE	MYISAM_OR_MARIA
857VERSION	10
858ROW_FORMAT	Fixed
859TABLE_ROWS	#TBLR#
860AVG_ROW_LENGTH	#ARL#
861DATA_LENGTH	#DL#
862MAX_DATA_LENGTH	#MDL#
863INDEX_LENGTH	#IL#
864DATA_FREE	#DF#
865AUTO_INCREMENT	NULL
866CREATE_TIME	#CRT#
867UPDATE_TIME	#UT#
868CHECK_TIME	#CT#
869TABLE_COLLATION	utf8_bin
870CHECKSUM	NULL
871CREATE_OPTIONS	#CO#
872TABLE_COMMENT	#TC#
873MAX_INDEX_LENGTH	#MIL#
874TEMPORARY	N
875user_comment	Database privileges
876Separator	-----------------------------------------------------
877TABLE_CATALOG	def
878TABLE_SCHEMA	mysql
879TABLE_NAME	event
880TABLE_TYPE	BASE TABLE
881ENGINE	MYISAM_OR_MARIA
882VERSION	10
883ROW_FORMAT	DYNAMIC_OR_PAGE
884TABLE_ROWS	#TBLR#
885AVG_ROW_LENGTH	#ARL#
886DATA_LENGTH	#DL#
887MAX_DATA_LENGTH	#MDL#
888INDEX_LENGTH	#IL#
889DATA_FREE	#DF#
890AUTO_INCREMENT	NULL
891CREATE_TIME	#CRT#
892UPDATE_TIME	#UT#
893CHECK_TIME	#CT#
894TABLE_COLLATION	utf8_general_ci
895CHECKSUM	NULL
896CREATE_OPTIONS	#CO#
897TABLE_COMMENT	#TC#
898MAX_INDEX_LENGTH	#MIL#
899TEMPORARY	N
900user_comment	Events
901Separator	-----------------------------------------------------
902TABLE_CATALOG	def
903TABLE_SCHEMA	mysql
904TABLE_NAME	func
905TABLE_TYPE	BASE TABLE
906ENGINE	MYISAM_OR_MARIA
907VERSION	10
908ROW_FORMAT	Fixed
909TABLE_ROWS	#TBLR#
910AVG_ROW_LENGTH	#ARL#
911DATA_LENGTH	#DL#
912MAX_DATA_LENGTH	#MDL#
913INDEX_LENGTH	#IL#
914DATA_FREE	#DF#
915AUTO_INCREMENT	NULL
916CREATE_TIME	#CRT#
917UPDATE_TIME	#UT#
918CHECK_TIME	#CT#
919TABLE_COLLATION	utf8_bin
920CHECKSUM	NULL
921CREATE_OPTIONS	#CO#
922TABLE_COMMENT	#TC#
923MAX_INDEX_LENGTH	#MIL#
924TEMPORARY	N
925user_comment	User defined functions
926Separator	-----------------------------------------------------
927TABLE_CATALOG	def
928TABLE_SCHEMA	mysql
929TABLE_NAME	general_log
930TABLE_TYPE	BASE TABLE
931ENGINE	CSV
932VERSION	10
933ROW_FORMAT	DYNAMIC_OR_PAGE
934TABLE_ROWS	#TBLR#
935AVG_ROW_LENGTH	#ARL#
936DATA_LENGTH	#DL#
937MAX_DATA_LENGTH	#MDL#
938INDEX_LENGTH	#IL#
939DATA_FREE	#DF#
940AUTO_INCREMENT	NULL
941CREATE_TIME	#CRT#
942UPDATE_TIME	#UT#
943CHECK_TIME	#CT#
944TABLE_COLLATION	utf8_general_ci
945CHECKSUM	NULL
946CREATE_OPTIONS	#CO#
947TABLE_COMMENT	#TC#
948MAX_INDEX_LENGTH	#MIL#
949TEMPORARY	N
950user_comment	General log
951Separator	-----------------------------------------------------
952TABLE_CATALOG	def
953TABLE_SCHEMA	mysql
954TABLE_NAME	gtid_slave_pos
955TABLE_TYPE	BASE TABLE
956ENGINE	MYISAM_OR_MARIA
957VERSION	10
958ROW_FORMAT	Fixed
959TABLE_ROWS	#TBLR#
960AVG_ROW_LENGTH	#ARL#
961DATA_LENGTH	#DL#
962MAX_DATA_LENGTH	#MDL#
963INDEX_LENGTH	#IL#
964DATA_FREE	#DF#
965AUTO_INCREMENT	NULL
966CREATE_TIME	#CRT#
967UPDATE_TIME	#UT#
968CHECK_TIME	#CT#
969TABLE_COLLATION	latin1_swedish_ci
970CHECKSUM	NULL
971CREATE_OPTIONS	#CO#
972TABLE_COMMENT	#TC#
973MAX_INDEX_LENGTH	#MIL#
974TEMPORARY	N
975user_comment	Replication slave GTID position
976Separator	-----------------------------------------------------
977TABLE_CATALOG	def
978TABLE_SCHEMA	mysql
979TABLE_NAME	help_category
980TABLE_TYPE	BASE TABLE
981ENGINE	MYISAM_OR_MARIA
982VERSION	10
983ROW_FORMAT	DYNAMIC_OR_PAGE
984TABLE_ROWS	#TBLR#
985AVG_ROW_LENGTH	#ARL#
986DATA_LENGTH	#DL#
987MAX_DATA_LENGTH	#MDL#
988INDEX_LENGTH	#IL#
989DATA_FREE	#DF#
990AUTO_INCREMENT	NULL
991CREATE_TIME	#CRT#
992UPDATE_TIME	#UT#
993CHECK_TIME	#CT#
994TABLE_COLLATION	utf8_general_ci
995CHECKSUM	NULL
996CREATE_OPTIONS	#CO#
997TABLE_COMMENT	#TC#
998MAX_INDEX_LENGTH	#MIL#
999TEMPORARY	N
1000user_comment	help categories
1001Separator	-----------------------------------------------------
1002TABLE_CATALOG	def
1003TABLE_SCHEMA	mysql
1004TABLE_NAME	help_keyword
1005TABLE_TYPE	BASE TABLE
1006ENGINE	MYISAM_OR_MARIA
1007VERSION	10
1008ROW_FORMAT	Fixed
1009TABLE_ROWS	#TBLR#
1010AVG_ROW_LENGTH	#ARL#
1011DATA_LENGTH	#DL#
1012MAX_DATA_LENGTH	#MDL#
1013INDEX_LENGTH	#IL#
1014DATA_FREE	#DF#
1015AUTO_INCREMENT	NULL
1016CREATE_TIME	#CRT#
1017UPDATE_TIME	#UT#
1018CHECK_TIME	#CT#
1019TABLE_COLLATION	utf8_general_ci
1020CHECKSUM	NULL
1021CREATE_OPTIONS	#CO#
1022TABLE_COMMENT	#TC#
1023MAX_INDEX_LENGTH	#MIL#
1024TEMPORARY	N
1025user_comment	help keywords
1026Separator	-----------------------------------------------------
1027TABLE_CATALOG	def
1028TABLE_SCHEMA	mysql
1029TABLE_NAME	help_relation
1030TABLE_TYPE	BASE TABLE
1031ENGINE	MYISAM_OR_MARIA
1032VERSION	10
1033ROW_FORMAT	Fixed
1034TABLE_ROWS	#TBLR#
1035AVG_ROW_LENGTH	#ARL#
1036DATA_LENGTH	#DL#
1037MAX_DATA_LENGTH	#MDL#
1038INDEX_LENGTH	#IL#
1039DATA_FREE	#DF#
1040AUTO_INCREMENT	NULL
1041CREATE_TIME	#CRT#
1042UPDATE_TIME	#UT#
1043CHECK_TIME	#CT#
1044TABLE_COLLATION	utf8_general_ci
1045CHECKSUM	NULL
1046CREATE_OPTIONS	#CO#
1047TABLE_COMMENT	#TC#
1048MAX_INDEX_LENGTH	#MIL#
1049TEMPORARY	N
1050user_comment	keyword-topic relation
1051Separator	-----------------------------------------------------
1052TABLE_CATALOG	def
1053TABLE_SCHEMA	mysql
1054TABLE_NAME	help_topic
1055TABLE_TYPE	BASE TABLE
1056ENGINE	MYISAM_OR_MARIA
1057VERSION	10
1058ROW_FORMAT	DYNAMIC_OR_PAGE
1059TABLE_ROWS	#TBLR#
1060AVG_ROW_LENGTH	#ARL#
1061DATA_LENGTH	#DL#
1062MAX_DATA_LENGTH	#MDL#
1063INDEX_LENGTH	#IL#
1064DATA_FREE	#DF#
1065AUTO_INCREMENT	NULL
1066CREATE_TIME	#CRT#
1067UPDATE_TIME	#UT#
1068CHECK_TIME	#CT#
1069TABLE_COLLATION	utf8_general_ci
1070CHECKSUM	NULL
1071CREATE_OPTIONS	#CO#
1072TABLE_COMMENT	#TC#
1073MAX_INDEX_LENGTH	#MIL#
1074TEMPORARY	N
1075user_comment	help topics
1076Separator	-----------------------------------------------------
1077TABLE_CATALOG	def
1078TABLE_SCHEMA	mysql
1079TABLE_NAME	host
1080TABLE_TYPE	BASE TABLE
1081ENGINE	MYISAM_OR_MARIA
1082VERSION	10
1083ROW_FORMAT	Fixed
1084TABLE_ROWS	#TBLR#
1085AVG_ROW_LENGTH	#ARL#
1086DATA_LENGTH	#DL#
1087MAX_DATA_LENGTH	#MDL#
1088INDEX_LENGTH	#IL#
1089DATA_FREE	#DF#
1090AUTO_INCREMENT	NULL
1091CREATE_TIME	#CRT#
1092UPDATE_TIME	#UT#
1093CHECK_TIME	#CT#
1094TABLE_COLLATION	utf8_bin
1095CHECKSUM	NULL
1096CREATE_OPTIONS	#CO#
1097TABLE_COMMENT	#TC#
1098MAX_INDEX_LENGTH	#MIL#
1099TEMPORARY	N
1100user_comment	Host privileges;  Merged with database privileges
1101Separator	-----------------------------------------------------
1102TABLE_CATALOG	def
1103TABLE_SCHEMA	mysql
1104TABLE_NAME	index_stats
1105TABLE_TYPE	BASE TABLE
1106ENGINE	MYISAM_OR_MARIA
1107VERSION	10
1108ROW_FORMAT	DYNAMIC_OR_PAGE
1109TABLE_ROWS	#TBLR#
1110AVG_ROW_LENGTH	#ARL#
1111DATA_LENGTH	#DL#
1112MAX_DATA_LENGTH	#MDL#
1113INDEX_LENGTH	#IL#
1114DATA_FREE	#DF#
1115AUTO_INCREMENT	NULL
1116CREATE_TIME	#CRT#
1117UPDATE_TIME	#UT#
1118CHECK_TIME	#CT#
1119TABLE_COLLATION	utf8_bin
1120CHECKSUM	NULL
1121CREATE_OPTIONS	#CO#
1122TABLE_COMMENT	#TC#
1123MAX_INDEX_LENGTH	#MIL#
1124TEMPORARY	N
1125user_comment	Statistics on Indexes
1126Separator	-----------------------------------------------------
1127TABLE_CATALOG	def
1128TABLE_SCHEMA	mysql
1129TABLE_NAME	innodb_index_stats
1130TABLE_TYPE	BASE TABLE
1131ENGINE	InnoDB
1132VERSION	10
1133ROW_FORMAT	DYNAMIC_OR_PAGE
1134TABLE_ROWS	#TBLR#
1135AVG_ROW_LENGTH	#ARL#
1136DATA_LENGTH	#DL#
1137MAX_DATA_LENGTH	#MDL#
1138INDEX_LENGTH	#IL#
1139DATA_FREE	#DF#
1140AUTO_INCREMENT	NULL
1141CREATE_TIME	#CRT#
1142UPDATE_TIME	#UT#
1143CHECK_TIME	#CT#
1144TABLE_COLLATION	utf8_bin
1145CHECKSUM	NULL
1146CREATE_OPTIONS	#CO#
1147TABLE_COMMENT	#TC#
1148MAX_INDEX_LENGTH	#MIL#
1149TEMPORARY	N
1150user_comment
1151Separator	-----------------------------------------------------
1152TABLE_CATALOG	def
1153TABLE_SCHEMA	mysql
1154TABLE_NAME	innodb_table_stats
1155TABLE_TYPE	BASE TABLE
1156ENGINE	InnoDB
1157VERSION	10
1158ROW_FORMAT	DYNAMIC_OR_PAGE
1159TABLE_ROWS	#TBLR#
1160AVG_ROW_LENGTH	#ARL#
1161DATA_LENGTH	#DL#
1162MAX_DATA_LENGTH	#MDL#
1163INDEX_LENGTH	#IL#
1164DATA_FREE	#DF#
1165AUTO_INCREMENT	NULL
1166CREATE_TIME	#CRT#
1167UPDATE_TIME	#UT#
1168CHECK_TIME	#CT#
1169TABLE_COLLATION	utf8_bin
1170CHECKSUM	NULL
1171CREATE_OPTIONS	#CO#
1172TABLE_COMMENT	#TC#
1173MAX_INDEX_LENGTH	#MIL#
1174TEMPORARY	N
1175user_comment
1176Separator	-----------------------------------------------------
1177TABLE_CATALOG	def
1178TABLE_SCHEMA	mysql
1179TABLE_NAME	plugin
1180TABLE_TYPE	BASE TABLE
1181ENGINE	MYISAM_OR_MARIA
1182VERSION	10
1183ROW_FORMAT	DYNAMIC_OR_PAGE
1184TABLE_ROWS	#TBLR#
1185AVG_ROW_LENGTH	#ARL#
1186DATA_LENGTH	#DL#
1187MAX_DATA_LENGTH	#MDL#
1188INDEX_LENGTH	#IL#
1189DATA_FREE	#DF#
1190AUTO_INCREMENT	NULL
1191CREATE_TIME	#CRT#
1192UPDATE_TIME	#UT#
1193CHECK_TIME	#CT#
1194TABLE_COLLATION	utf8_general_ci
1195CHECKSUM	NULL
1196CREATE_OPTIONS	#CO#
1197TABLE_COMMENT	#TC#
1198MAX_INDEX_LENGTH	#MIL#
1199TEMPORARY	N
1200user_comment	MySQL plugins
1201Separator	-----------------------------------------------------
1202TABLE_CATALOG	def
1203TABLE_SCHEMA	mysql
1204TABLE_NAME	proc
1205TABLE_TYPE	BASE TABLE
1206ENGINE	MYISAM_OR_MARIA
1207VERSION	10
1208ROW_FORMAT	DYNAMIC_OR_PAGE
1209TABLE_ROWS	#TBLR#
1210AVG_ROW_LENGTH	#ARL#
1211DATA_LENGTH	#DL#
1212MAX_DATA_LENGTH	#MDL#
1213INDEX_LENGTH	#IL#
1214DATA_FREE	#DF#
1215AUTO_INCREMENT	NULL
1216CREATE_TIME	#CRT#
1217UPDATE_TIME	#UT#
1218CHECK_TIME	#CT#
1219TABLE_COLLATION	utf8_general_ci
1220CHECKSUM	NULL
1221CREATE_OPTIONS	#CO#
1222TABLE_COMMENT	#TC#
1223MAX_INDEX_LENGTH	#MIL#
1224TEMPORARY	N
1225user_comment	Stored Procedures
1226Separator	-----------------------------------------------------
1227TABLE_CATALOG	def
1228TABLE_SCHEMA	mysql
1229TABLE_NAME	procs_priv
1230TABLE_TYPE	BASE TABLE
1231ENGINE	MYISAM_OR_MARIA
1232VERSION	10
1233ROW_FORMAT	Fixed
1234TABLE_ROWS	#TBLR#
1235AVG_ROW_LENGTH	#ARL#
1236DATA_LENGTH	#DL#
1237MAX_DATA_LENGTH	#MDL#
1238INDEX_LENGTH	#IL#
1239DATA_FREE	#DF#
1240AUTO_INCREMENT	NULL
1241CREATE_TIME	#CRT#
1242UPDATE_TIME	#UT#
1243CHECK_TIME	#CT#
1244TABLE_COLLATION	utf8_bin
1245CHECKSUM	NULL
1246CREATE_OPTIONS	#CO#
1247TABLE_COMMENT	#TC#
1248MAX_INDEX_LENGTH	#MIL#
1249TEMPORARY	N
1250user_comment	Procedure privileges
1251Separator	-----------------------------------------------------
1252TABLE_CATALOG	def
1253TABLE_SCHEMA	mysql
1254TABLE_NAME	proxies_priv
1255TABLE_TYPE	BASE TABLE
1256ENGINE	MYISAM_OR_MARIA
1257VERSION	10
1258ROW_FORMAT	Fixed
1259TABLE_ROWS	#TBLR#
1260AVG_ROW_LENGTH	#ARL#
1261DATA_LENGTH	#DL#
1262MAX_DATA_LENGTH	#MDL#
1263INDEX_LENGTH	#IL#
1264DATA_FREE	#DF#
1265AUTO_INCREMENT	NULL
1266CREATE_TIME	#CRT#
1267UPDATE_TIME	#UT#
1268CHECK_TIME	#CT#
1269TABLE_COLLATION	utf8_bin
1270CHECKSUM	NULL
1271CREATE_OPTIONS	#CO#
1272TABLE_COMMENT	#TC#
1273MAX_INDEX_LENGTH	#MIL#
1274TEMPORARY	N
1275user_comment	User proxy privileges
1276Separator	-----------------------------------------------------
1277TABLE_CATALOG	def
1278TABLE_SCHEMA	mysql
1279TABLE_NAME	roles_mapping
1280TABLE_TYPE	BASE TABLE
1281ENGINE	MYISAM_OR_MARIA
1282VERSION	10
1283ROW_FORMAT	Fixed
1284TABLE_ROWS	#TBLR#
1285AVG_ROW_LENGTH	#ARL#
1286DATA_LENGTH	#DL#
1287MAX_DATA_LENGTH	#MDL#
1288INDEX_LENGTH	#IL#
1289DATA_FREE	#DF#
1290AUTO_INCREMENT	NULL
1291CREATE_TIME	#CRT#
1292UPDATE_TIME	#UT#
1293CHECK_TIME	#CT#
1294TABLE_COLLATION	utf8_bin
1295CHECKSUM	NULL
1296CREATE_OPTIONS	#CO#
1297TABLE_COMMENT	#TC#
1298MAX_INDEX_LENGTH	#MIL#
1299TEMPORARY	N
1300user_comment	Granted roles
1301Separator	-----------------------------------------------------
1302TABLE_CATALOG	def
1303TABLE_SCHEMA	mysql
1304TABLE_NAME	servers
1305TABLE_TYPE	BASE TABLE
1306ENGINE	MYISAM_OR_MARIA
1307VERSION	10
1308ROW_FORMAT	DYNAMIC_OR_PAGE
1309TABLE_ROWS	#TBLR#
1310AVG_ROW_LENGTH	#ARL#
1311DATA_LENGTH	#DL#
1312MAX_DATA_LENGTH	#MDL#
1313INDEX_LENGTH	#IL#
1314DATA_FREE	#DF#
1315AUTO_INCREMENT	NULL
1316CREATE_TIME	#CRT#
1317UPDATE_TIME	#UT#
1318CHECK_TIME	#CT#
1319TABLE_COLLATION	utf8_general_ci
1320CHECKSUM	NULL
1321CREATE_OPTIONS	#CO#
1322TABLE_COMMENT	#TC#
1323MAX_INDEX_LENGTH	#MIL#
1324TEMPORARY	N
1325user_comment	MySQL Foreign Servers table
1326Separator	-----------------------------------------------------
1327TABLE_CATALOG	def
1328TABLE_SCHEMA	mysql
1329TABLE_NAME	slow_log
1330TABLE_TYPE	BASE TABLE
1331ENGINE	CSV
1332VERSION	10
1333ROW_FORMAT	DYNAMIC_OR_PAGE
1334TABLE_ROWS	#TBLR#
1335AVG_ROW_LENGTH	#ARL#
1336DATA_LENGTH	#DL#
1337MAX_DATA_LENGTH	#MDL#
1338INDEX_LENGTH	#IL#
1339DATA_FREE	#DF#
1340AUTO_INCREMENT	NULL
1341CREATE_TIME	#CRT#
1342UPDATE_TIME	#UT#
1343CHECK_TIME	#CT#
1344TABLE_COLLATION	utf8_general_ci
1345CHECKSUM	NULL
1346CREATE_OPTIONS	#CO#
1347TABLE_COMMENT	#TC#
1348MAX_INDEX_LENGTH	#MIL#
1349TEMPORARY	N
1350user_comment	Slow log
1351Separator	-----------------------------------------------------
1352TABLE_CATALOG	def
1353TABLE_SCHEMA	mysql
1354TABLE_NAME	tables_priv
1355TABLE_TYPE	BASE TABLE
1356ENGINE	MYISAM_OR_MARIA
1357VERSION	10
1358ROW_FORMAT	Fixed
1359TABLE_ROWS	#TBLR#
1360AVG_ROW_LENGTH	#ARL#
1361DATA_LENGTH	#DL#
1362MAX_DATA_LENGTH	#MDL#
1363INDEX_LENGTH	#IL#
1364DATA_FREE	#DF#
1365AUTO_INCREMENT	NULL
1366CREATE_TIME	#CRT#
1367UPDATE_TIME	#UT#
1368CHECK_TIME	#CT#
1369TABLE_COLLATION	utf8_bin
1370CHECKSUM	NULL
1371CREATE_OPTIONS	#CO#
1372TABLE_COMMENT	#TC#
1373MAX_INDEX_LENGTH	#MIL#
1374TEMPORARY	N
1375user_comment	Table privileges
1376Separator	-----------------------------------------------------
1377TABLE_CATALOG	def
1378TABLE_SCHEMA	mysql
1379TABLE_NAME	table_stats
1380TABLE_TYPE	BASE TABLE
1381ENGINE	MYISAM_OR_MARIA
1382VERSION	10
1383ROW_FORMAT	DYNAMIC_OR_PAGE
1384TABLE_ROWS	#TBLR#
1385AVG_ROW_LENGTH	#ARL#
1386DATA_LENGTH	#DL#
1387MAX_DATA_LENGTH	#MDL#
1388INDEX_LENGTH	#IL#
1389DATA_FREE	#DF#
1390AUTO_INCREMENT	NULL
1391CREATE_TIME	#CRT#
1392UPDATE_TIME	#UT#
1393CHECK_TIME	#CT#
1394TABLE_COLLATION	utf8_bin
1395CHECKSUM	NULL
1396CREATE_OPTIONS	#CO#
1397TABLE_COMMENT	#TC#
1398MAX_INDEX_LENGTH	#MIL#
1399TEMPORARY	N
1400user_comment	Statistics on Tables
1401Separator	-----------------------------------------------------
1402TABLE_CATALOG	def
1403TABLE_SCHEMA	mysql
1404TABLE_NAME	time_zone
1405TABLE_TYPE	BASE TABLE
1406ENGINE	MYISAM_OR_MARIA
1407VERSION	10
1408ROW_FORMAT	Fixed
1409TABLE_ROWS	#TBLR#
1410AVG_ROW_LENGTH	#ARL#
1411DATA_LENGTH	#DL#
1412MAX_DATA_LENGTH	#MDL#
1413INDEX_LENGTH	#IL#
1414DATA_FREE	#DF#
1415AUTO_INCREMENT	6
1416CREATE_TIME	#CRT#
1417UPDATE_TIME	#UT#
1418CHECK_TIME	#CT#
1419TABLE_COLLATION	utf8_general_ci
1420CHECKSUM	NULL
1421CREATE_OPTIONS	#CO#
1422TABLE_COMMENT	#TC#
1423MAX_INDEX_LENGTH	#MIL#
1424TEMPORARY	N
1425user_comment	Time zones
1426Separator	-----------------------------------------------------
1427TABLE_CATALOG	def
1428TABLE_SCHEMA	mysql
1429TABLE_NAME	time_zone_leap_second
1430TABLE_TYPE	BASE TABLE
1431ENGINE	MYISAM_OR_MARIA
1432VERSION	10
1433ROW_FORMAT	Fixed
1434TABLE_ROWS	#TBLR#
1435AVG_ROW_LENGTH	#ARL#
1436DATA_LENGTH	#DL#
1437MAX_DATA_LENGTH	#MDL#
1438INDEX_LENGTH	#IL#
1439DATA_FREE	#DF#
1440AUTO_INCREMENT	NULL
1441CREATE_TIME	#CRT#
1442UPDATE_TIME	#UT#
1443CHECK_TIME	#CT#
1444TABLE_COLLATION	utf8_general_ci
1445CHECKSUM	NULL
1446CREATE_OPTIONS	#CO#
1447TABLE_COMMENT	#TC#
1448MAX_INDEX_LENGTH	#MIL#
1449TEMPORARY	N
1450user_comment	Leap seconds information for time zones
1451Separator	-----------------------------------------------------
1452TABLE_CATALOG	def
1453TABLE_SCHEMA	mysql
1454TABLE_NAME	time_zone_name
1455TABLE_TYPE	BASE TABLE
1456ENGINE	MYISAM_OR_MARIA
1457VERSION	10
1458ROW_FORMAT	Fixed
1459TABLE_ROWS	#TBLR#
1460AVG_ROW_LENGTH	#ARL#
1461DATA_LENGTH	#DL#
1462MAX_DATA_LENGTH	#MDL#
1463INDEX_LENGTH	#IL#
1464DATA_FREE	#DF#
1465AUTO_INCREMENT	NULL
1466CREATE_TIME	#CRT#
1467UPDATE_TIME	#UT#
1468CHECK_TIME	#CT#
1469TABLE_COLLATION	utf8_general_ci
1470CHECKSUM	NULL
1471CREATE_OPTIONS	#CO#
1472TABLE_COMMENT	#TC#
1473MAX_INDEX_LENGTH	#MIL#
1474TEMPORARY	N
1475user_comment	Time zone names
1476Separator	-----------------------------------------------------
1477TABLE_CATALOG	def
1478TABLE_SCHEMA	mysql
1479TABLE_NAME	time_zone_transition
1480TABLE_TYPE	BASE TABLE
1481ENGINE	MYISAM_OR_MARIA
1482VERSION	10
1483ROW_FORMAT	Fixed
1484TABLE_ROWS	#TBLR#
1485AVG_ROW_LENGTH	#ARL#
1486DATA_LENGTH	#DL#
1487MAX_DATA_LENGTH	#MDL#
1488INDEX_LENGTH	#IL#
1489DATA_FREE	#DF#
1490AUTO_INCREMENT	NULL
1491CREATE_TIME	#CRT#
1492UPDATE_TIME	#UT#
1493CHECK_TIME	#CT#
1494TABLE_COLLATION	utf8_general_ci
1495CHECKSUM	NULL
1496CREATE_OPTIONS	#CO#
1497TABLE_COMMENT	#TC#
1498MAX_INDEX_LENGTH	#MIL#
1499TEMPORARY	N
1500user_comment	Time zone transitions
1501Separator	-----------------------------------------------------
1502TABLE_CATALOG	def
1503TABLE_SCHEMA	mysql
1504TABLE_NAME	time_zone_transition_type
1505TABLE_TYPE	BASE TABLE
1506ENGINE	MYISAM_OR_MARIA
1507VERSION	10
1508ROW_FORMAT	Fixed
1509TABLE_ROWS	#TBLR#
1510AVG_ROW_LENGTH	#ARL#
1511DATA_LENGTH	#DL#
1512MAX_DATA_LENGTH	#MDL#
1513INDEX_LENGTH	#IL#
1514DATA_FREE	#DF#
1515AUTO_INCREMENT	NULL
1516CREATE_TIME	#CRT#
1517UPDATE_TIME	#UT#
1518CHECK_TIME	#CT#
1519TABLE_COLLATION	utf8_general_ci
1520CHECKSUM	NULL
1521CREATE_OPTIONS	#CO#
1522TABLE_COMMENT	#TC#
1523MAX_INDEX_LENGTH	#MIL#
1524TEMPORARY	N
1525user_comment	Time zone transition types
1526Separator	-----------------------------------------------------
1527TABLE_CATALOG	def
1528TABLE_SCHEMA	mysql
1529TABLE_NAME	transaction_registry
1530TABLE_TYPE	BASE TABLE
1531ENGINE	InnoDB
1532VERSION	10
1533ROW_FORMAT	DYNAMIC_OR_PAGE
1534TABLE_ROWS	#TBLR#
1535AVG_ROW_LENGTH	#ARL#
1536DATA_LENGTH	#DL#
1537MAX_DATA_LENGTH	#MDL#
1538INDEX_LENGTH	#IL#
1539DATA_FREE	#DF#
1540AUTO_INCREMENT	NULL
1541CREATE_TIME	#CRT#
1542UPDATE_TIME	#UT#
1543CHECK_TIME	#CT#
1544TABLE_COLLATION	utf8_bin
1545CHECKSUM	NULL
1546CREATE_OPTIONS	#CO#
1547TABLE_COMMENT	#TC#
1548MAX_INDEX_LENGTH	#MIL#
1549TEMPORARY	N
1550user_comment
1551Separator	-----------------------------------------------------
1552TABLE_CATALOG	def
1553TABLE_SCHEMA	mysql
1554TABLE_NAME	user
1555TABLE_TYPE	BASE TABLE
1556ENGINE	MYISAM_OR_MARIA
1557VERSION	10
1558ROW_FORMAT	DYNAMIC_OR_PAGE
1559TABLE_ROWS	#TBLR#
1560AVG_ROW_LENGTH	#ARL#
1561DATA_LENGTH	#DL#
1562MAX_DATA_LENGTH	#MDL#
1563INDEX_LENGTH	#IL#
1564DATA_FREE	#DF#
1565AUTO_INCREMENT	NULL
1566CREATE_TIME	#CRT#
1567UPDATE_TIME	#UT#
1568CHECK_TIME	#CT#
1569TABLE_COLLATION	utf8_bin
1570CHECKSUM	NULL
1571CREATE_OPTIONS	#CO#
1572TABLE_COMMENT	#TC#
1573MAX_INDEX_LENGTH	#MIL#
1574TEMPORARY	N
1575user_comment	Users and global privileges
1576Separator	-----------------------------------------------------
1577connection default;
1578disconnect testuser1;
1579DROP USER testuser1@localhost;
1580DROP DATABASE test1;
1581