Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html
In the Server field, enter the name of the MySQL server host to access. Debug lets you turn on ODBC debugging to record the queries you execute through the DSN to the myodbc.sql file. SSL configures the additional options required for using the ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's capabilities The client should only announce the capabilities in the Handshake Response Packet that it has in common with the ...They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support ...
https://dev.mysql.com/doc/internals/en/public-key-retrieval-example.html
set --default-authentication-plugin=sha256_password for the MySQL server: 46 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 04 F....5.6.7-log.. set --default-auth=sha256_password for the MySQL client, don't provide it with the servers public-key and ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html
This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. For more information on reserved words and their impact on your queries, see Keywords and Reserved Words, in ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-synchronous-transactions.html
It first creates a database ndb_examples and a table api_simple (if these objects do not already exist) using the MySQL C API with an SQL node, then performs a series of basic data operations (insert, update, read, and select) on this table using ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-22.html
Now, it is permitted to send passwords without hashing or encryption by using mysql_clear_password on the client side together with any server-side plugin that needs a clear text password, such as for LDAP pluggable authentication. Connector/NET ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
If Server Group is set to Read-Only, or higher, it is impossible to set MySQL Instances to None. That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at least. Administer: access to the MySQL instances, ...MySQL Instances: grants access to the data collected on the monitored MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation. Warning User-defined ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
mysql> UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name like 'events_waits%'; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 You can verify that wait event consumers are enabled by querying the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. MyISAM table maintenance can also be done using the SQL statements ...