Show active connections along with their ciphers in MySQL.

mysql-connection-ciphers.md

Sometimes it can be useful to know which ciphers certain connections are utilising, this will how you the active connections along with their ciphers if applicable.

Reference: https://security.stackexchange.com/a/260139/40579

SELECT t.THREAD_ID,
       t.PROCESSLIST_USER,
       t.PROCESSLIST_HOST,
       t.CONNECTION_TYPE,
       sbt.VARIABLE_VALUE AS cipher
FROM performance_schema.threads t
LEFT JOIN performance_schema.status_by_thread sbt
ON (t.THREAD_ID = sbt.THREAD_ID AND sbt.VARIABLE_NAME = 'Ssl_cipher')
WHERE t.PROCESSLIST_USER IS NOT NULL;