This walkthrough gives you an idea about how the network protocol that MySQL uses functions.

• Authentication: mysql_native_password, caching_sha2_password and more
• Secure connections with TLS
• Queries, Resultsets and Prepared statements
• Compression with zlib and zstd
• Connection attributes
• Replication

This is based on work I have done on the MySQL protocol dissector in Wireshark