As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect.
In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI.
The first thing we can check is that all our clients encrypt their connection to the MySQL server.
We use again
Performance_Schema to retrieve the
select connection_type, substring_index(substring_index(name,"/",2),"/",-1) name, sbt.variable_value AS tls_version, t2.variable_value AS cipher, processlist_user AS user, processlist_host AS host from performance_schema.status_by_thread AS sbt join performance_schema.threads AS t on t.thread_id = sbt.thread_id join performance_schema.status_by_thread AS t2 on t2.thread_id = t.thread_id where sbt.variable_name = 'Ssl_version' and …