Using WinMySQL Professional

Kill connection

Only accessible when connected, the «Server administration>Kill connection» submenu allows any user to kill its own connection (what a bad way to disconnect !). It is what the MySQL® user's manual tells us. In fact, on many MySQL® servers, a user without any specific privilege can kill connection of all users with the same name and password (but with another thread ID). To prevent a WinMySQL Professional crash during transactions, due to connections killed by another user, you should check the «anticrash socket» option in the «connection parameters» window (if your MySQL® server allows it) : see the «Submenu File>Connection parameters» section.

With the anticrash socket, a killed connection will drive to a clean disconnection of WinMySQL Professional when it will detect that its thread is dead. Then, you can easy reconnect yourself striking the «F2» key. See the «Submenu File>Connect/Disconnect» section. If a connection is not protected by the anticrash socket, WinMySQL Professional will try to open a new connection socket (a new thread, in fact), but if it was waiting a query result from the server, just before its connection was killed, it risks to provocate an ugly «memory violation».

If a user must manage connections, his privileges should be granted with the «Can manage processes» right. You can grant users privileges with the submenu «Server administration>Manage users privileges» .

To kill a connection, click on the «Server administration>Kill connection» submenu. In the connections list window, select the connection that you want to kill (verify carefully the username, the station, the databasename and the thread ID before processing) ; then click on the «Kill» button.