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