Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
Therefore, do not pass instant date-time types (java.util.Calendar, java.util.Date, java.time.OffsetDateTime, java.sql.Timestamp) to non-instant date-time types (for example, java.sql.DATE, java.time.LocalDate, java.time.LocalTime, ...A time instant ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
Therefore, do not pass instant date-time types (java.util.Calendar, java.util.Date, java.time.OffsetDateTime, java.sql.Timestamp) to non-instant date-time types (for example, java.sql.DATE, java.time.LocalDate, java.time.LocalTime, ...A time instant ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to authenticate MySQL users. PAM pluggable authentication provides these capabilities: External authentication: PAM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINES This statement can be ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
The goal for your backup strategy is to minimize downtime, using techniques such as hot backup for InnoDB tables and minimizing the duration of the suspend stage where you run customized backup logic while the MySQL server is locked. MySQL ... These ...apply The operation that transforms a raw backup into a prepared backup by incorporating changes that occurred while the backup was running, using data from the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format Backups”. By default, mysqldump writes information as SQL statements to the ...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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
A copy of the index file on the MySQL server that lists all the used binary log files, with the locations of the binary log files properly updated to point to the files' locations in the backup, is included into the backup as well also under the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...If you are replicating partitioned tables, using different SQL modes on the source and the replica is likely to cause ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
The SQL query tab is a secondary tab that opens by default when you make a connection to a MySQL server. The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, ...Each editor opens in a separate secondary tab within an active MySQL connection ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For programs that use the C API, call mysql_options() to specify the RSA public key file by passing the MYSQL_SERVER_PUBLIC_KEY option and the name of the file, or request the public key from the server by passing the MYSQL_OPT_GET_SERVER_PUBLIC_KEY ... 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 ...