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, `USER` varchar(128) NOT NULL, `HOST` varchar(64) NOT NULL, `DB` varchar(64), `COMMAND` varchar(16) NOT NULL, `TIME` int(7) NOT NULL, `STATE` varchar(64), `INFO` longtext, `TIME_MS` decimal(22,3) NOT NULL, `STAGE` tinyint(2) NOT NULL, `MAX_STAGE` tinyint(2) NOT NULL, `PROGRESS` decimal(7,3) NOT NULL, `MEMORY_USED` bigint(7) NOT NULL, `MAX_MEMORY_USED` bigint(7) NOT NULL, `EXAMINED_ROWS` int(7) NOT NULL, `QUERY_ID` bigint(4) NOT NULL, `INFO_BINARY` blob, `TID` bigint(4) NOT NULL ) 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