MySQL Server has since version 5.6 supported connection
attributes for the clients. This has allowed a client to provide
information such as which program or connector the client is, the
client version, the license, etc. The database administrator can
use this information for example to verify whether all clients
have been upgraded, which client is executing a particular query,
and so forth.
In MySQL 8.0.16 this feature has been included for the X DevAPI
in the MySQL connectors as well, including MySQL Connector/Python
which I will cover in this blog. First though, let’s take a look
at how the attributes are exposed in MySQL Server.
The built-in MySQL Connector/Python connection
attributesConnection Attributes in MySQL Server
The …[Read more]