Search Results
https://dev.mysql.com/doc/refman/8.4/en/source-installation-methods.html
There are two methods for installing MySQL from source: Use a standard MySQL source distribution. To obtain a standard distribution, see Section 2.1.3, “How to Get MySQL”. For instructions on building from a standard distribution, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. STOP REPLICA requires the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER privilege). Recommended best practice is to execute STOP ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. Stored routines can be particularly ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on ...
https://dev.mysql.com/doc/refman/8.4/en/uln-installation.html
If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. If a change of build is involved, we recommend the ... Linux supports a number of different solutions for installing MySQL, covered in Section 2.5, “Installing MySQL on ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported.
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
MySQL is available for Microsoft Windows 64-bit operating systems only. There are different methods to install MySQL on Microsoft Windows: the MSI, the standard binary distribution (packaged as a compressed file) containing all of the necessary ...