The world's most popular open source database
This tab displays all connections to the server (threads), but in
a different way than the
Threads
tab does: You will see users rather than individual threads. The
number of connections for each user is listed under
Num.. Right-clicking on a username and
selecting Show User Infos displays 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 the
order by clicking on the headings (Num.,
Full Name, or
Description).
Clicking on a username will display the individual threads of that
user in the lower box of the tab, ordered by
PID. Likewise, you can change the order by
clicking on one of the headings.
Clicking on a user will enable the Kill User button, allowing you to terminate all threads of that user with a single click. This command is also available by right clicking on the username. Clicking on an individual thread in the lower box enables the Kill Thread button, which is used to terminate a connection. This command is also available by right clicking on a thread.
To reload the user list from the server, press the Refresh button.

