Search Results
https://dev.mysql.com/doc/internals/en/authentication-method-change.html
the client connecting to the server the server responds with the Initial Handshake Packet the client sends the Handshake Response Packet the server responds with the Authentication Method Switch Request Packet to tell the client which ...
https://dev.mysql.com/doc/internals/en/authentication-method.html
For earlier servers it is always Secure Password Authentication or Old Password Authentication depending on the CLIENT_SECURE_CONNECTION flag. Client and server negotiate what types of authentication they support as part of the connection phase.
https://dev.mysql.com/doc/internals/en/binlog-network-stream.html
Network streams are requested with COM_BINLOG_DUMP and prepend each Binlog Event with 00 OK-byte.
https://dev.mysql.com/doc/internals/en/com-binlog-dump-gtid.html
If the binlog-filename is empty, the server will send the binlog-stream of the first known binlog.
https://dev.mysql.com/doc/internals/en/com-change-user.html
COM_CHANGE_USER changes the user of the current connection and reset the connection state. and others It is followed by the same states as the initial handshake.
https://dev.mysql.com/doc/internals/en/com-register-slave.html
Fields server_id (4) -- the slaves server-id slave_hostname (string.var_len) -- see report_host, usually empty slave_user (string.var_len) -- see report_user, usually empty slave_password (string.var_len) -- see report_password, usually empty ...
https://dev.mysql.com/doc/internals/en/compression.html
Compression is its own protocol, is transparent to the rest of the MySQL protocol and compresses a stream of bytes (which may even be a part of several Protocol::Packet). It is enabled if the server announces CLIENT_COMPRESS in its ...
https://dev.mysql.com/doc/internals/en/cs-sect-expired-password.html
Since MySQL 5.6.7, a MySQL account can be expired with ALTER USER account PASSWORD EXPIRE. All other statements fail with an error like this: mysql> SELECT 1; ERROR 1820 (HY000): You must SET PASSWORD before executing this statement On the protocol ...If a account is expired, the session is in a restricted mode which only permits SET PASSWORD ...
https://dev.mysql.com/doc/internals/en/debug-sync-implementation.html
Pseudo code for a synchronization point: #define DEBUG_SYNC(thd, sync_point_name) if (unlikely(opt_debug_sync_timeout)) debug_sync(thd, STRING_WITH_LEN(sync_point_name)) The synchronization point performs a binary search in a sorted array of ...
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Only then server can look-up the mysql.user table and find the authentication method to be used. Up to MySQL 4.0 the MySQL protocol only ...Client informs about the user account it wants to log into in the Handshake Response ...