DROP USER test_user@'localhost'; CREATE USER test_user@'localhost'; GRANT ALL ON *.* TO test_user@'localhost'; REVOKE PROCESS ON *.* FROM test_user@'localhost'; SET PASSWORD FOR test_user@'localhost' = PASSWORD('ddictpass'); DROP TABLE IF EXISTS test.t1; CREATE TABLE test.t1 (f1 BIGINT); USE test; # Show the definition of the PROCESSLIST table #-------------------------------------------------------------------------- SHOW CREATE TABLE INFORMATION_SCHEMA.PROCESSLIST; Table Create Table PROCESSLIST CREATE TEMPORARY TABLE `PROCESSLIST` ( `ID` bigint(4) NOT NULL DEFAULT 0, `USER` varchar(128) NOT NULL DEFAULT '', `HOST` varchar(64) NOT NULL DEFAULT '', `DB` varchar(64) DEFAULT NULL, `COMMAND` varchar(16) NOT NULL DEFAULT '', `TIME` int(7) NOT NULL DEFAULT 0, `STATE` varchar(64) DEFAULT NULL, `INFO` longtext DEFAULT NULL, `TIME_MS` decimal(22,3) NOT NULL DEFAULT 0.000, `STAGE` tinyint(2) NOT NULL DEFAULT 0, `MAX_STAGE` tinyint(2) NOT NULL DEFAULT 0, `PROGRESS` decimal(7,3) NOT NULL DEFAULT 0.000, `MEMORY_USED` bigint(7) NOT NULL DEFAULT 0, `MAX_MEMORY_USED` bigint(7) NOT NULL DEFAULT 0, `EXAMINED_ROWS` int(7) NOT NULL DEFAULT 0, `QUERY_ID` bigint(4) NOT NULL DEFAULT 0, `INFO_BINARY` blob DEFAULT NULL, `TID` bigint(4) NOT NULL DEFAULT 0 ) DEFAULT CHARSET=utf8 # Ensure that the information about the own connection is correct. #-------------------------------------------------------------------------- SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; ID USER HOST DB COMMAND TIME STATE INFO TIME_MS STAGE MAX_STAGE PROGRESS MEMORY_USED MAX_MEMORY_USED EXAMINED_ROWS QUERY_ID INFO_BINARY TID root test Execute