Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-macos.html
To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example: $> myodbc-installer -a -s -t"DSN=mydb;DRIVER=MySQL ODBC 9.6 Driver;SERVER=mysql;USER=username;PASSWORD=pass" To use ... To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC Administrator ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-constructor.html
Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. If this argument is not given, Connector/Python automatically generates the name, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-set-config.html
Syntax: cnxpool.set_config(**kwargs) This method sets the configuration parameters for connections in the pool. Connections requested from the pool after the configuration change use the new parameters. Connections obtained before the change remain ...Example: dbconfig = { "database": "performance_schema", "user": "admin", "password": "password", } ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorraw.html
To create a raw cursor, use the raw argument when calling a connection's cursor() method. Alternatively, to make all cursors created from the connection raw by default, use the raw connection argument. Example: import mysql.connector cnx = ...A ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. We then create a new cursor, by default a MySQLCursor object, using the connection's cursor() method. Connector/Python converts hire_start ...The task is to select all employees hired in the year 1999 and print their names and hire dates to the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Note The following example uses tables created in the example Section 5.2, “Creating Tables Using Connector/Python”. We then create a new cursor, by default a MySQLCursor object, using the connection's cursor() method. Since by default ...
https://dev.mysql.com/doc/internals/en/com-change-user-and-non-client-plugin-auth-clients.html
In this case it is assumed that server has already sent the authentication challenge - the same which was sent when the client connected for the first time - and client's reply to that challenge, i.e. the server responds with OK_Packet and returns ... Clients which do not support pluggable authentication can send COM_CHANGE_USER command for accounts which use Secure Password Authentication or Old Password ...
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/insufficient-client-capabilities.html
Server will reject connection with ERR_Packet if it discovers that client capabilities are not sufficient to complete authenticaiton. This can happen in the following situations: A client which does not support pluggable authentication ...Server's ...
https://dev.mysql.com/doc/internals/en/threads.html
Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define CONNECT_PRIOR 9 #define WAIT_PRIOR 8 #define QUERY_PRIOR 6 Some threads try to set their priority; others don't. These calls are ...