Search Results
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
For statements that insert or ignore new rows, or that replace or modify existing rows, based on values in a PRIMARY KEY or UNIQUE index, MySQL treats invisible columns the same as visible columns: Invisible columns participate in key value ...An ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
The UPDATE statement uses any of the three functions JSON_SET(), JSON_REPLACE(), or JSON_REMOVE() to update the column. All changes replace existing array or object values with new ones, and do not add any new elements to the parent object or array.
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. The statement may also include a ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
ssl-ca SSL Certificate - Alias of SSLCA as an eventual replacement; added in v8.0.29. ssl-capath SSL CA Path - Alias of SSLCAPATH as an eventual replacement; added in v8.0.29. ssl-cert SSL Certificate - Alias of SSLCERT as an eventual replacement; ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
ssl-ca SSL Certificate - Alias of SSLCA as an eventual replacement; added in v8.0.29. ssl-capath SSL CA Path - Alias of SSLCAPATH as an eventual replacement; added in v8.0.29. ssl-cert SSL Certificate - Alias of SSLCERT as an eventual replacement; ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/security-advisors-ref.html
Default frequency 00:05:00 Default auto-close enabled no Symlinks Are Enabled You can move tables and databases from the database directory to other locations and replace them with symbolic links to the new locations. If a user is configured to use ...Note MySQL Enterprise Firewall and MySQL Enterprise Audit Plug-in advisors are described in MySQL Enterprise Firewall and MySQL Enterprise Audit ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
It is possible to rotate keys to allow for pending keys to replace active keys before the active keys expire. Only the database administrator responsible for this cluster should have the pass phrase. Knowing the pass phrase would allow an attacker ... 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/fulltext-boolean.html
YourSQL','When comparing databases ...'), -> ('MySQL Security','When configured properly, MySQL ...'), -> ('Database, Database, Database','database database database'), -> ('1001 MySQL Tricks','1. | 0.36289870738983154 | | 1 | MySQL Tutorial | This ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...