Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). Note If the replication ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Error number: 2072; Symbol: CR_INVALID_FACTOR_NO; Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. */ MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1, /** occurs after COM_CHANGE_USER RPC is completed. */ MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
They are often created for existing databases, to clarify their purpose or document them. MySQL Workbench provides facilities for reverse engineering existing databases, and then creating an EER Diagram automatically. The plugin created in this ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. What this means is that we can create a Java interface and only use the operations on this interface without any internal knowledge of what the ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-scaffold-example.html
The resulting entities are created and mapped to the tables in the specified database. Scaffolding a Database Using .NET Core CLI Initialize a valid .NET Core project and console application using the .NET Core command-line interface (CLI) and then ... Scaffolding a database produces an Entity Framework model from an existing ...