Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator.html
MySQL Configurator is a standalone application designed to ease the complexity of configuring a MySQL server to run MySQL on Microsoft Windows. It is bundled with the MySQL server, in both the MSI and standalone Zip archive. Methods to Start MySQL ...From the Start Menu: the MSI creates a MySQL Configurator start menu ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. (This is also useful for testing downgrades.) On the production server: $> ... When ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
Therefore, to allow a server to be restored to a point-in-time, binary logging must be enabled on it, which is the default setting for MySQL 8.4 (see Section 7.4.4, “The Binary Log”). By default, the server creates binary log files in the data ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-compatibility.html
The use of more than two MySQL Server versions is not supported in replication setups involving multiple sources, regardless of the number of source or replica MySQL servers. The server version is recorded in the binary log for each transaction for ... MySQL supports replication from an older source to a newer replica for version combinations where we support upgrades from the source version to the replica version as described at Section 1.3, “MySQL Releases: Innovation and LTS” and Section 3.2, “Upgrade ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. The source on which the event was ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
As a result, the server retrieves every row in the table. Even if it is permissible to display any row in the database, you should still protect against denial of service attacks (for example, those that are based on the technique in the preceding ... Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. Support The server's level of support for the storage engine, as shown in the following table. A value of DISABLED occurs either because the server ...This is particularly useful for checking whether a storage engine is supported, or to see what the default engine ...
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. Stored routines can provide improved performance because less information needs to be sent between the server and the client. The tradeoff is that this does increase the ...Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens.html
MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. Version token lists are established per server (for example, to ...The Version Tokens interface has these characteristics: Version tokens are pairs consisting of a name that serves as a key or identifier, plus a ...