mysql\bin\mysqld.exe, Version: 5.6.37 (MySQL Community Server (GPL)). started with: TCP Port: 3306, Named Pipe: C:/Ampps/mysql/mysql.sock Time Id Command Argument 180706 7:59:11 8 Query SHOW GLOBAL VARIABLES WHERE Variable_name="general_log" 8 Quit 180706 7:59:13 9 Connect root@localhost on 9 Query SET CHARACTER SET 'utf8mb4' 9 Query SET collation_connection = 'utf8mb4_unicode_ci' 9 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 9 Init DB mysql 9 Quit 180706 7:59:18 10 Connect root@localhost on 10 Query SET CHARACTER SET 'utf8mb4' 10 Query SET collation_connection = 'utf8mb4_unicode_ci' 10 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 10 Quit 180706 7:59:21 11 Connect root@localhost on 11 Query SET CHARACTER SET 'utf8mb4' 11 Query SET collation_connection = 'utf8mb4_unicode_ci' 11 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 11 Query select '' 11 Query SHOW VARIABLES LIKE 'profiling' 11 Quit 180706 10:24:28 12 Connect root@localhost on 12 Query SELECT @@version, @@version_comment 12 Query SHOW VARIABLES LIKE 'character_set_results' 12 Query SET CHARACTER SET 'utf8mb4' 12 Query SET collation_connection = 'utf8mb4_unicode_ci' 12 Query SELECT * FROM information_schema.CHARACTER_SETS 12 Query SELECT * FROM information_schema.COLLATIONS 12 Query SELECT 1 FROM mysql.user LIMIT 1 12 Query SHOW GRANTS 12 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 12 Query SELECT CURRENT_USER() 12 Query SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`COLUMN_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`TABLE_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES`) t WHERE `IS_GRANTABLE` = 'YES' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 12 Query SELECT CURRENT_USER() 12 Query SELECT 1 FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE `PRIVILEGE_TYPE` = 'CREATE USER' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 12 Init DB mysql 12 Query SELECT USER() 12 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC 12 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 12 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 12 Query SHOW MASTER LOGS 12 Quit 180706 10:49:10 13 Connect root@localhost on 13 Query SELECT @@version, @@version_comment 13 Query SHOW VARIABLES LIKE 'character_set_results' 13 Query SET CHARACTER SET 'utf8mb4' 13 Query SET collation_connection = 'utf8mb4_unicode_ci' 13 Query SELECT * FROM information_schema.CHARACTER_SETS 13 Query SELECT * FROM information_schema.COLLATIONS 13 Query SELECT 1 FROM mysql.user LIMIT 1 13 Query SHOW GRANTS 13 Query SHOW TABLES FROM `'"-->` 13 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 13 Query SELECT @@lc_messages 13 Query SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < '''"-->' ) t 13 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC 13 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 13 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 13 Query SHOW TABLES FROM `'"-->` 13 Query SELECT CURRENT_USER() 13 Query SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`COLUMN_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`TABLE_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES`) t WHERE `IS_GRANTABLE` = 'YES' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 13 Query SELECT CURRENT_USER() 13 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT' 13 Query SELECT CURRENT_USER() 13 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER' 13 Query SHOW TABLES FROM `'"-->` 13 Query SELECT CURRENT_USER() 13 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT' 13 Query SELECT CURRENT_USER() 13 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER' 13 Quit 180706 14:09:19 14 Connect root@localhost on 14 Query SELECT @@version, @@version_comment 14 Query SHOW VARIABLES LIKE 'character_set_results' 14 Query SET CHARACTER SET 'utf8mb4' 14 Query SET collation_connection = 'utf8mb4_unicode_ci' 14 Query SELECT * FROM information_schema.CHARACTER_SETS 14 Query SELECT * FROM information_schema.COLLATIONS 14 Query SELECT 1 FROM mysql.user LIMIT 1 14 Query SHOW GRANTS 14 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 14 Query SELECT CURRENT_USER() 14 Query SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`COLUMN_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`TABLE_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES`) t WHERE `IS_GRANTABLE` = 'YES' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 14 Query SELECT CURRENT_USER() 14 Query SELECT 1 FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE `PRIVILEGE_TYPE` = 'CREATE USER' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 14 Init DB mysql 14 Query SELECT USER() 180706 14:09:20 14 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC 14 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 14 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 14 Query SHOW MASTER LOGS 14 Quit 15 Connect root@localhost on 15 Query SELECT @@version, @@version_comment 15 Query SHOW VARIABLES LIKE 'character_set_results' 15 Query SET CHARACTER SET 'utf8mb4' 15 Query SET collation_connection = 'utf8mb4_unicode_ci' 15 Query SELECT * FROM information_schema.CHARACTER_SETS 15 Query SELECT * FROM information_schema.COLLATIONS 15 Query SELECT 1 FROM mysql.user LIMIT 1 15 Query SHOW GRANTS 15 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA` 15 Query SELECT CURRENT_USER() 15 Query SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`COLUMN_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`TABLE_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` UNION SELECT `GRANTEE`, `IS_GRANTABLE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES`) t WHERE `IS_GRANTABLE` = 'YES' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 15 Query SELECT CURRENT_USER() 15 Query SELECT 1 FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE `PRIVILEGE_TYPE` = 'CREATE USER' AND '''root''@''localhost''' LIKE `GRANTEE` LIMIT 1 15 Init DB mysql 15 Query SELECT USER() 15 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC 15 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 15 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP '(mysql|information_schema|performance_schema)' ) t 15 Query SHOW MASTER LOGS 15 Quit