MySQL Administrator :: 8.3 User Connections

This tab displays all connections to the server (threads), but in a different way than the Threads tab does: You will rather see users, not individual threads in the first place. The number of connections a user has currently established to the MySQL server is listed under Num.. Right-clicking on a username and selecting Show User Info will also display the Full Name and the Description, as specified in the User Information tab of the User Administration section. Initially, users are sorted by their MySQL Username, but you can change that order by clicking on the appropriate headings (Num., Full Name, or Description). Clicking on a username will display the individual threads of that user in the lower box of that tab, ordered by PID. Likewise, you can change that order by clicking on the appropriate headings.

Clicking on a user will enable the Kill User button, which allows you to terminate all threads of that user with a single click. That command is also available by right-clicking on the username. Clicking on an individual thread in the lower box will enable the Kill Thread button, which is used to terminate a connection. That command is available by right-clicking on a thread, too.

To reload the user list from the server, press the Refresh button.