Search Results
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/better-protocols-example.html
The output becomes less clear because there is no indication that the connection has been changed. SET @aux = 1; SELECT @aux AS "content of @aux is"; content of @aux is 1 SELECT @aux AS "content of @aux is"; content of @aux is NULL .
https://dev.mysql.com/doc/internals/en/binlog-formats.html
If the server cannot determine that a statement is correctly logged, a warning or error shall be issued: If it is possible that the user (through application-specific logic) knows that the statement is correctly logged, then a warning shall be ...
https://dev.mysql.com/doc/internals/en/client-wants-native-server-wants-old.html
$ mysql --default-auth=mysql_native_password ## against a mysql_old_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5d 0a 00 00 66 5c 7b 74 55 2d 7b 4b 00 ff g.]...f\{tU-{K.. Handshake ...ff 08 02 00 0f c0 15 00 00 00 00 00 00 00 00 00 ...
https://dev.mysql.com/doc/internals/en/client-wants-old-server-wants-native.html
$ mysql --default-auth=mysql_old_password ## against a mysql_native_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5b 0a 00 00 6c 2e 3e 2f 6c 55 44 36 00 ff g.[...l.>/lUD6.. Handshake ...ff 08 02 00 0f c0 15 00 00 00 00 00 00 00 00 00 ...
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/connection-phase-packets.html
username (string.fix_len) -- name of the SQL account which client wants to log in -- this string should be interpreted using the character set indicated by character set field. It is like Handshake Response Packet but is truncated right before ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
Any intermediate state of the slave is identical to some intermediate state of the master. Note: it is not required that each intermediate state of the master is identical to some intermediate state of the slave. We now state the architectural ...
https://dev.mysql.com/doc/internals/en/error-messages-storage-engine.html
For example: Got error 788 'Could not connect to remote server fed.bb.pl' from FEDERATED The Got error %d part will be returned in the user's selected language, but the handler-specific one will use English (unless the handler supports returning the ... To add error messages for table handlers, the following example may be ...
https://dev.mysql.com/doc/internals/en/guided-tour-flow.html
The flow works like this: First, the client routines get an SQL statement from a user, allowing edit, performing initial checks, and so on. Then, via the vio routines, the somewhat-massaged statement goes off to the server. Next, the sql routines ...