Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-connect.html
import _mysql_connector ccnx = _mysql_connector.MySQL() ccnx.connect(user='scott', password='password', host='127.0.0.1', database='employees') ccnx.close() connect() supports the following arguments: host, user, password, database, port, ...If ccnx ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysql-connector-connect.html
A connection with the MySQL server can be established using either the mysql.connector.connect() method or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-set-charset-collation.html
In the following example, we set the character set to latin1 and the collation to latin1_swedish_ci (the default collation for: latin1): >>> cnx = mysql.connector.connect(user='scott') >>> cnx.set_charset_collation('latin1') Specify a given ...
https://dev.mysql.com/doc/internals/en/a-mysql-client-logs-in.html
The client answers with username, some flags and the response to the challenge.: server -> client 07 00 00 02 00 00 00 02 00 00 00 ........... 06 55 53 45 52 28 29 00 0c 08 00 4d 00 00 00 fd .USER()....M.... 00 00 27 75 3e 6f 38 66 79 4e 00 ff f7 08 ...
https://dev.mysql.com/doc/internals/en/auth-phase-fast-path.html
Assume that client wants to log in as user U and that user account uses authentication method M. The fast authentication path is used if both client and server used method M to generate authentication data in the initial handshake. In that case the ...
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 ...