Search Results
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
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 ...This is deprecated and subject to removal, do not use this authentication ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-dns-srv.html
MySQL supports the use of DNS SRV records for connecting to servers. A client that receives a DNS SRV lookup result attempts to connect to the MySQL server on each of the listed hosts in order of preference, based on the priority and weighting ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. MySQL supports encrypted connections ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. If the server disconnects the client, it returns an ER_MUST_CHANGE_PASSWORD_LOGIN error: $> mysql -u myuser -p ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
A hash join is used even if any pair of joined tables does not have at least one equi-join condition, as shown here: mysql> EXPLAIN FORMAT=TREE -> SELECT * FROM t1 -> JOIN t2 ON (t1.c1 = t2.c1) -> JOIN t3 ON (t2.c1 < t3.c1)\G ...It is possible to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
The default setting of interleaved lock mode in MySQL 8.4 reflects the change from statement-based replication to row based replication as the default replication type. InnoDB provides a configurable locking mechanism that can significantly improve ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the recommended method for backing up InnoDB data. Hot Backups The ... The ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. For example, if mysqld was started with the local_infile system variable disabled, LOCAL produces an error. For example, if ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
That is, MySQL account management supports accounts that use 2FA or 3FA, in addition to the existing 1FA support. When a client attempts a connection to the MySQL server using a single-factor account, the server invokes the authentication plugin ...