Setting program_name in mysql session_connect_attrs allows you to see the name of the program connected
I am using mysql for quite some time now. I have noticed that looking at client connections using mysql workbench so an interesting column called "Program". I can see that the program column indicate "MySQL Workbench": This column can be very useful and help to filter different mysql database connections. It took me a while to understand how to set up this column data. So first thing I needed to do is understand where is this column name is actually coming from. I inspected the "SHOW FULL PROCESSLIST" command by mysql - but I did not get any answer there. I then looked at the query the mysql workbench itself running to get this data "Program" column: Using the "show details" button in the "client connections" view, show me this: Copying the query, it looks like that: SELECT t.PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USER, t.PROCESSLIST_HOST, ...