MySQL Client/Server ProtocolMySQL Client/Server protocol is used in server operations to create, read, interpret, and send protocol packets between MySQL Clients and a MySQL Server. It is implemented by connectors, MySQL Proxy and communication between master and slave replication servers. The protocol supports the following features:
- Transparent encryption using SSL
- Transparent compression
- Command phase that is used to accept commands from the server and execute them
- Connection phase that performs SSL communication setup and authentication between the client and the server
- Client connects to the server
- Server sends a handshake packet to the client
- Client sends an auth-packet
- Server allows the transaction or retrieves an error message
- Client sends a COM_* packet
- Server sends one of the following: OK, Error, EOF (End of File) message or a result-set.
Next, does your MySQL or other database contains a sensitive data that has to be secured and protected? Or do you need to be in compliance with GDPR, SOX or HIPAA? Check DataSunrise database security and data masking software or download the trial .