PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode ... This section lists environment variables that are used directly or indirectly by ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_kerberos_service_key_tab Command-Line Format --authentication-kerberos-service-key-tab=file_name System Variable authentication_kerberos_service_key_tab Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create temporary tables Context: Databases ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
Do not forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. Important MySQL 8.0 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. MySQL Installer automatically installs MySQL Server and ...Users should make sure the package has been installed on the system before installing the ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If a session has open temporary tables, the replication format cannot be changed for the session (SET @@SESSION.binlog_format). If any ... You can select the binary logging format explicitly by starting the MySQL server with ...