Search Results
https://dev.mysql.com/doc/refman/8.4/en/functions.html
(See Section 7.1.11, “Server SQL Modes”.) Individual client programs can request this behavior by using the CLIENT_IGNORE_SPACE option for mysql_real_connect(). For information about loadable functions and stored functions, see Section 7.7, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-source.html
Building NDB Cluster from source is similar to building the standard MySQL Server, although it differs in a few key respects discussed here. MySQL NDB Cluster 8.4 is built from the MySQL Server 8.4 sources, available from the MySQL downloads page at ...For general information about building MySQL from source, see Section 2.8, “Installing MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
Warning Operations performed on Cluster table indexes using the NDB API are not visible to MySQL and make the table unusable by a MySQL server. Your MySQL connection id is 7 to server version: 5.7.44-ndb-7.5.36 Type 'help;' or '\h' for help. It is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
The logging format in a running MySQL server is controlled by setting the binlog_format server system variable. The rules governing when and how the new setting takes effect are the same as for other MySQL server system variables. The correlation ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration file. To convert a table from one storage engine to another, use an ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
During the normal startup sequence, the server loads functions registered in the mysql.func table. Unlike the mysql.func table, the user_defined_functions table also lists loadable functions installed automatically by server components or plugins.
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
The auto_increment_increment value should be greater than the number of servers, and each server should have a unique offset. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with ...For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform multiple-table deletes, see Section 15.2.2, “DELETE ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It also saves the value, causing it to carry over to subsequent server restarts. To change the value for the running MySQL instance without having it carry over to subsequent restarts, use the GLOBAL keyword rather than PERSIST. The server records ...For example, it is possible to permit an account to modify any table except those in the mysql system ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.5/en/news-9-5-0.html
(Bug #38237729) Utilities Bugs Fixed MySQL Shell could close unexpectedly when running the upgrade checker utility on a MySQL Server 5.7. Errors were returned similar to the following: ERROR: Error executing SQL statement for schema `schemaName`: ...
https://dev.mysql.com/doc/internals/en/authentication-method.html
For earlier servers it is always Secure Password Authentication or Old Password Authentication depending on the CLIENT_SECURE_CONNECTION flag. Client and server negotiate what types of authentication they support as part of the connection phase.