Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-perror.html
ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent or temporary. This is intended as a drop-in replacement for perror --ndb, which is no ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
If the tool finds existing key and certificate files, it renames them to reflect their retired status, and saves the newly created key and certificate as active files; the new files are used the next time that the node is restarted. This creates a ... This section discusses the implementation and use of Transport Layer Security (TLS) to secure network communications in MySQL NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
Invoke mysql_config_editor like this: mysql_config_editor [program_options] command [command_options] If the login path file does not exist, mysql_config_editor creates it. --warn, -w Warn and prompt the user for confirmation if the command attempts ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-server-side-help.html
For example, HELP rep% returns a list of topics that begin with rep: mysql> HELP rep% Many help items for your request exist. mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. This section describes how to use mysqldump to create delimited-text dump files. For ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This ensures that when the dump file is reloaded, it creates each database if it does not exist and makes it the default database so database contents are loaded into the same database from which they came. If the database to be reloaded does not ...
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. Attempts to create a new user account or to alter an existing ... MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable ...
https://dev.mysql.com/doc/refman/8.4/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
Option File Processing Order Option File Syntax Option File Inclusions Option File Processing Order MySQL looks for option files in the order described in the following discussion and reads any that exist. If an option file you want to use does not ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
However, STRAIGHT_JOIN may prevent indexes from being used because it disables semijoin transformations; see Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations. MySQL implements an A LEFT JOIN B join_specification as follows: ...