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(16) 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 ) ENGINE=MyISAM 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 root test Execute