Search Results
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
Basic information on their usage and abilities is provided here for reference purposes only. MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to MySQL resources using either the classic ...
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. When the read_only system ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
row *************************** Table: child Create Table: CREATE TABLE `child` ( `id` int DEFAULT NULL, `parent_id` int DEFAULT NULL, KEY `par_ind` (`parent_id`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 extension), the extended key usage must include client authentication (clientAuth). There is no extendedKeyUsage ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
The primary use case is modification of statements restored from dump files, so the typical usage pattern is: 1) Install the plugin; 2) restore the dump file or files; 3) uninstall the plugin. This section describes how to install or uninstall the ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
The command mysqladmin debug dumps some information about locks in use, used memory and query usage to the MySQL log file. If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
TREE provides tree-like output with more precise descriptions of query handling than the TRADITIONAL format; it is the only format which shows hash join usage (see Section 10.2.1.4, “Hash Join Optimization”) and is always used for EXPLAIN ...In ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Usage of OpenSSL was unified in 2018 (in MySQL 8.0.4 and 5.7.28, respectively). Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”. Installation can be performed using a graphical interface or manually: On Windows, ...