Bug #92620 Client Connections Showing incorrect Host and User for Slave_IO and Slave_SQL
Submitted: 1 Oct 2018 13:08 Modified: 15 Oct 2019 6:20
Reporter: IGG t Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.12, 8.0.18 OS:Microsoft Windows (10)
Assigned to: CPU Architecture:Other (x64)
Tags: host, PROCESSLIST, user

[1 Oct 2018 13:08] IGG t
I am running MySQL Workbench 8.0.12 on Windows 10. I am connecting to MySQL 5.7.23 running on Debian Linux.

When I open the Client Connections tab and look at the Slave_IO and Slave_SQL threads, on one database the user and host all show as 'None', and on the other they show as 'root','' (e.g. my current login).

I have checked a few other 5.7.23 databases and some of them show with my ip address and some of them show 'none'.

Surely they should all show show as none.

Both Databases have been restarted recently, and are set up with identical configuration.

How to repeat:
Open CLient Connections tab and look at the user and host fields against the slave_io and slave_sql threads.

Suggested fix:
Ensure they always show as none
[15 Oct 2019 6:20] MySQL Verification Team
Hello IGG t,

Thank you for the report.
Verified as described.

Ashwini Patil