Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
If you have updated an existing MySQL installation to a newer version, did you perform the MySQL upgrade procedure? If not, do so. Because that row has a Host value 'localhost' that is more specific than '%', it is used in preference to the new row ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
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-howto-masterstatus.html
Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. If you are planning to shut down the source to create a data snapshot, you can optionally skip this procedure and instead store a copy of the ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
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 want to downgrade to an earlier version of MySQL, you can do so now, using the normal downgrade procedure. This section describes how to disable ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Note Statements that update the information in the mysql system schema, such as GRANT, REVOKE and the manipulation of triggers, stored routines (including stored procedures), and views, are all replicated to replicas using statement-based ...For ...
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/rewriter-query-rewrite-plugin-usage.html
When you load the rules table by calling the flush_rewrite_rules() stored procedure, if an error occurs for some rule, the CALL statement produces an error, and the plugin sets the Rewriter_reload_error status variable to ON: mysql> CALL ... To ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. A loadable function named load_rewrite_rules() is used by the flush_rewrite_rules() stored procedure.
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
sha256_password also supports encrypted password exchange using RSA over unencrypted connections if MySQL is compiled using OpenSSL, and the MySQL server to which you wish to connect is configured to support RSA (using the RSA configuration ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.