Bug #92620 Client Connections Showing incorrect Host and User for Slave_IO and Slave_SQL
Submitted: 1 Oct 2018 13:08
Reporter: IGG t Email Updates:
Status: Open Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.12 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