Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
The MySQL binary logs are important for recovery because they form the set of incremental backups. This incremental backup is important, so it is a good idea to copy it to a safe place. A full backup (a snapshot of the data at a point in time) can ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
Important In MySQL 8.4, caching_sha2_password is the default authentication plugin rather than mysql_native_password (deprecated). Important To connect to the server using an account that authenticates with the caching_sha2_password plugin, you must ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
The following modes are permissible: DISABLED PREFERRED REQUIRED VERIFY_CA VERIFY_IDENTITY Important VERIFY_CA and VERIFY_IDENTITY are better choices than the default PREFERRED, because they help prevent man-in-the-middle attacks. Important Percent ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
This enables you to import the tables in any order in case the dump file contains tables that are not correctly ordered for foreign keys. Disabling foreign_key_checks also speeds up the import operation by avoiding foreign key checks. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
DISCARD TABLESPACE and ALTER TABLE ...IMPORT TABLESPACE are not supported for tables that belong to a general tablespace. The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
Important Under some circumstances, CREATE USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information.
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
Important Whatever method you use to generate the certificate and key files, the Common Name value used for the server and client certificates/keys must each differ from the Common Name value used for the CA certificate. A typical error in this case ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
Important Server autogeneration helps lower the barrier to using SSL by making it easier to generate the required files. Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
For example, store semi-important data that can be regenerated on a RAID 0 disk, but store really important data such as host information and logs on a RAID 0+1 or RAID N disk. This section describes ways to configure storage devices when you can ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. It is important to know what the '>, ">, and `> prompts signify, ...