Search Results
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and client forms: The server-side plugin is built into the server, but is disabled by default. To enable it, start the MySQL Server with ... MySQL includes ...When the plugin is disabled, all of the operations that depend on the plugin are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
To ensure no file permission issues prevent a server to be backed up, restored, and restarted successfully, it is highly recommended that you run mysqlbackup with the same OS user who runs the MySQL server (typically mysql). Note For Linux and other ... For Linux and other Unix-like platforms: mysqlbackup does not record file ownership or permissions of the files that are backed ...For an offline restore, you might need to, for example, set a umask to the user before the restore and adjust the permissions of the restored files and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-19.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. This patch adjusts Connector/J to those recent changes of MySQL Server and, as a result, DatabaseMetaData, ParameterMetaData, and ResultSetMetaData now report identical results for ... Version 8.0.19 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-routing.html
Connection routing means redirecting MySQL connections to an available MySQL server. Applications connect to MySQL Router and not directly to MySQL Server, and if the connection fails then applications are designed to retry the connection because ...Routed servers and routing strategies are defined in a configuration ...For an example deployment using ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Each subclause provides a subquery that produces a result set, and associates a name with the subquery. They are defined using a WITH clause: with_clause: WITH [RECURSIVE] cte_name [(col_name [, col_name] ...)] AS (subquery) [, cte_name [(col_name ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
| +-----------------------------------------+ Note The previous example does not work as shown if the NO_BACKSLASH_ESCAPES server SQL mode is enabled. You can compare the results shown by this query: mysql> SELECT -> JSON_MERGE_PRESERVE('[1, 2]', ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same host. Suppose a cluster is running a ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
For InnoDB-specific tuning techniques you can apply to your MySQL server and application code, see Section 10.5, “Optimizing for InnoDB Tables”. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware ...InnoDB crash recovery automatically finalizes changes that were committed before the time of the crash, and undoes changes that were in process but not committed, permitting you to restart and continue from where you left ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. The default value is 'en_US' regardless of your system's locale setting, but you can set the value at server ...