Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
CREATE PROCEDURE IF NOT EXISTS, CREATE FUNCTION IF NOT EXISTS, or CREATE TRIGGER IF NOT EXISTS, if successful, is written in its entirety to the binary log (including the IF NOT EXISTS clause), whether or not the statement raised a warning because ...IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
This procedure does not require taking the server offline and is suited to use in production. If you use binary logs for anything other than replication—for example, to perform point-in-time backup or restore—wait until you no longer need any ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
B.3.3.2.1 Resetting the Root Password: Windows Systems On Windows, use the following procedure to reset the password for the MySQL 'root'@'localhost' account. B.3.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems On Unix, use the ... If ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading.html
Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first on some test systems to make sure everything works smoothly, and ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
To reconfigure the TLS context at runtime, use this procedure: Set each TLS context-related system variable that should be changed to its new value. The members of each pair of system and status variables may have different values temporarily due to ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
Use of database symlinks on Windows is similar to their use on Unix, although the procedure for setting up the link differs. On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
Then, before calling mysql_stmt_execute() to execute the statement, use the following procedure to set up each temporal parameter: In the MYSQL_BIND structure associated with the data value, set the buffer_type member to the type that indicates what ... The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-native-function.html
To add a native MySQL function, use the procedure described here, which requires that you use a source distribution. If you migrate to another version of MySQL (for example, when a new version is released), you must repeat the procedure with the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-16.html
(Bug #25650385) X DevAPI: Any statements sent after a failed procedure call caused Connector/J to hang. With this fix, an error is thrown when the procedure call fails, and the result streamer is nullified. (Bug #29318273) In the ... Version 8.0.16 ...