Databases

• Create database  
  Collation armscii8_bin armscii8_general_ci ascii_bin ascii_general_ci big5_bin big5_chinese_ci binary cp1250_bin cp1250_croatian_ci cp1250_czech_cs cp1250_general_ci cp1250_polish_ci cp1251_bin cp1251_bulgarian_ci cp1251_general_ci cp1251_general_cs cp1251_ukrainian_ci cp1256_bin cp1256_general_ci cp1257_bin cp1257_general_ci cp1257_lithuanian_ci cp850_bin cp850_general_ci cp852_bin cp852_general_ci cp866_bin cp866_general_ci cp932_bin cp932_japanese_ci dec8_bin dec8_swedish_ci eucjpms_bin eucjpms_japanese_ci euckr_bin euckr_korean_ci gb2312_bin gb2312_chinese_ci gbk_bin gbk_chinese_ci geostd8_bin geostd8_general_ci greek_bin greek_general_ci hebrew_bin hebrew_general_ci hp8_bin hp8_english_ci keybcs2_bin keybcs2_general_ci koi8r_bin koi8r_general_ci koi8u_bin koi8u_general_ci latin1_bin latin1_danish_ci latin1_general_ci latin1_general_cs latin1_german1_ci latin1_german2_ci latin1_spanish_ci latin1_swedish_ci latin2_bin latin2_croatian_ci latin2_czech_cs latin2_general_ci latin2_hungarian_ci latin5_bin latin5_turkish_ci latin7_bin latin7_estonian_cs latin7_general_ci latin7_general_cs macce_bin macce_general_ci macroman_bin macroman_general_ci sjis_bin sjis_japanese_ci swe7_bin swe7_swedish_ci tis620_bin tis620_thai_ci ucs2_bin ucs2_croatian_ci ucs2_croatian_mysql561_ci ucs2_czech_ci ucs2_danish_ci ucs2_esperanto_ci ucs2_estonian_ci ucs2_general_ci ucs2_general_mysql500_ci ucs2_german2_ci ucs2_hungarian_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_lithuanian_ci ucs2_myanmar_ci ucs2_persian_ci ucs2_polish_ci ucs2_roman_ci ucs2_romanian_ci ucs2_sinhala_ci ucs2_slovak_ci ucs2_slovenian_ci ucs2_spanish2_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_thai_520_w2 ucs2_turkish_ci ucs2_unicode_520_ci ucs2_unicode_ci ucs2_vietnamese_ci ujis_bin ujis_japanese_ci utf16_bin utf16_croatian_ci utf16_croatian_mysql561_ci utf16_czech_ci utf16_danish_ci utf16_esperanto_ci utf16_estonian_ci utf16_general_ci utf16_german2_ci utf16_hungarian_ci utf16_icelandic_ci utf16_latvian_ci utf16_lithuanian_ci utf16_myanmar_ci utf16_persian_ci utf16_polish_ci utf16_roman_ci utf16_romanian_ci utf16_sinhala_ci utf16_slovak_ci utf16_slovenian_ci utf16_spanish2_ci utf16_spanish_ci utf16_swedish_ci utf16_thai_520_w2 utf16_turkish_ci utf16_unicode_520_ci utf16_unicode_ci utf16_vietnamese_ci utf16le_bin utf16le_general_ci utf32_bin utf32_croatian_ci utf32_croatian_mysql561_ci utf32_czech_ci utf32_danish_ci utf32_esperanto_ci utf32_estonian_ci utf32_general_ci utf32_german2_ci utf32_hungarian_ci utf32_icelandic_ci utf32_latvian_ci utf32_lithuanian_ci utf32_myanmar_ci utf32_persian_ci utf32_polish_ci utf32_roman_ci utf32_romanian_ci utf32_sinhala_ci utf32_slovak_ci utf32_slovenian_ci utf32_spanish2_ci utf32_spanish_ci utf32_swedish_ci utf32_thai_520_w2 utf32_turkish_ci utf32_unicode_520_ci utf32_unicode_ci utf32_vietnamese_ci utf8_bin utf8_croatian_ci utf8_croatian_mysql561_ci utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_general_ci utf8_general_mysql500_ci utf8_german2_ci utf8_hungarian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_myanmar_ci utf8_persian_ci utf8_polish_ci utf8_roman_ci utf8_romanian_ci utf8_sinhala_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_thai_520_w2 utf8_turkish_ci utf8_unicode_520_ci utf8_unicode_ci utf8_vietnamese_ci utf8mb4_bin utf8mb4_croatian_ci utf8mb4_croatian_mysql561_ci utf8mb4_czech_ci utf8mb4_danish_ci utf8mb4_esperanto_ci utf8mb4_estonian_ci utf8mb4_general_ci utf8mb4_german2_ci utf8mb4_hungarian_ci utf8mb4_icelandic_ci utf8mb4_latvian_ci utf8mb4_lithuanian_ci utf8mb4_myanmar_ci utf8mb4_persian_ci utf8mb4_polish_ci utf8mb4_roman_ci utf8mb4_romanian_ci utf8mb4_sinhala_ci utf8mb4_slovak_ci utf8mb4_slovenian_ci utf8mb4_spanish2_ci utf8mb4_spanish_ci utf8mb4_swedish_ci utf8mb4_thai_520_w2 utf8mb4_turkish_ci utf8mb4_unicode_520_ci utf8mb4_unicode_ci utf8mb4_vietnamese_ci

	Database	Collation	Action
	crt	latin1_swedish_ci	Check privileges
	information_schema	utf8_general_ci	Check privileges
	iottest	latin1_swedish_ci	Check privileges
	mysql	latin1_swedish_ci	Check privileges
	performance_schema	utf8_general_ci	Check privileges
	phpmyadmin	utf8_bin	Check privileges
	punjabiotp	latin1_swedish_ci	Check privileges
	punjab_iot	latin1_swedish_ci	Check privileges
	rip	latin1_swedish_ci	Check privileges
	schema	latin1_swedish_ci	Check privileges
	test	latin1_swedish_ci	Check privileges
	testiot	latin1_swedish_ci	Check privileges
	testrmc	latin1_swedish_ci	Check privileges
	u1	latin1_swedish_ci	Check privileges
	woc	latin1_swedish_ci	Check privileges
	Total: 15	latin1_swedish_ci

Check all With selected:  Drop

Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.

• Enable statistics