Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-user.html
If count is 0 (the default), the server determines the number of simultaneous connections for the account from the global value of the max_user_connections system variable. When the read_only system variable is enabled, CREATE USER additionally ...
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
A server started with the persisted_globals_load system variable disabled does not read mysqld-auto.cnf. MYSQL_HOME is an environment variable containing the path to the directory in which the server-specific my.cnf file resides. To specify an ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Message Structure Messages have a: 4 byte length (little endian) 1 byte message type a message_payload of length .length - 1 Mysqlx.Message Container of all messages that are exchanged between client and server. A message sequence either: finishes ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-3-0.html
(Bug #36298807) Replication: The replica_parallel_workers server system variable can no longer be set to 0; the minimum permitted value is now 1. (Bug #36686351) Authentication Notes This release introduces a MySQL component, ...To avoid build ...
https://dev.mysql.com/doc/connectors/en/connector-net-authentication.html
MIT Kerberos must be installed on each client system to enable authentication of request tickets for Connector/NET by a MySQL server. MIT Kerberos must be installed on each client system to enable authentication of request tickets for Connector/NET ... MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
MIT Kerberos must be installed on each client system to enable authentication of request tickets for Connector/NET by a MySQL server. Minimum version: SCRAM-SHA-1: Connector/NET 8.0.22 SCRAM-SHA-256: Connector/NET 8.0.23 GSSAPI: Connector/NET 8.0.24 ... MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a ...
https://dev.mysql.com/doc/refman/9.7/en/flush.html
Signals can be sent by the root system account or the system account that owns the server process. If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the ...By default, the server writes FLUSH statements to the binary log so that they replicate to ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines-syntax.html
The top-level properties of a routing guideline document are: destinations: groupings of MySQL servers using pattern-matching expressions. The following example shows a default destination class for an InnoDB Cluster: "destinations": [ { "match": ...Only online topology members are considered when forming a candidate ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.backup.html
240426 13:01:24 RDR1 INFO: Reading all global variables from the server. 240426 13:01:24 RDR1 INFO: Completed reading of all 623 global variables from the server. 240426 13:01:23 MAIN INFO: MySQL server version is '8.4.0-commercial' 240426 13:01:23 ... In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image command, which appears at the end of the sample ...
https://dev.mysql.com/doc/refman/9.7/en/load-data.html
The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents using the character set indicated by the character_set_database system ...For ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...