Search Results
https://dev.mysql.com/doc/internals/en/authentication-fails.html
Server indicates that client is not permitted to connect by sending ERR_Packet.
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/capability-flags.html
CLIENT_CONNECT_WITH_DB Database (schema) name can be specified on connect in Handshake Response Packet. Note this value was CLIENT_CHANGE_USER in 3.22, unused in 4.0 CLIENT_INTERACTIVE wait_timeout versus wait_interactive_timeout. See ... The ...
https://dev.mysql.com/doc/internals/en/libmysql-directory.html
The files here are for producing MySQL as a library (for example, a Windows DLL). The idea is that, instead of producing separate mysql (client) and mysqld (server) programs, one produces a library. Instead of sending messages, the client part ...
https://dev.mysql.com/doc/internals/en/sleep.html
Example: --connection conn1 LOCK TABLE t1 WRITE; --connection conn2 # This will block in wait_for_lock(). send INSERT INTO t1 VALUES (1); --connection conn1 # Sleep until we can be sure that conn2 reached wait_for_lock(). In some cases race ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
Example: --connection conn1 LOCK TABLE t1 WRITE; --connection conn2 # Get the id of this thread. send INSERT INTO t1 VALUES (1); --connection conn1 # Specify the condition that shows if conn2 reached wait_for_lock(). Like 'sleep', this method can ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-workflow-nonserver-products.html
Classic MySQL protocol connections to InnoDB Cluster Read/Write: Set the first base port number to one that is unused (between 80 and 65532) and the wizard will select the remaining ports for you. Regardless of where the router and client are ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
See Also load(T) , newInstance(java.lang.Class<T>, java.lang.Object) 4.3.1.22.13 getConnection() public abstract Connection getConnection(); Get the underlying database connection used by this session 4.3.1.22.14 getQueryBuilder() public abstract ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-java.html
When using JDBC, you must write the SQL, manage the connection, and copy any data from the result set that you want to use in your program as objects. The JDBC implementation most often used with the MySQL Server is MySQL Connector/J. Using ... A ...