PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
Create a text file containing the password-assignment statement on a single line. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause ... If ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
When a caller invokes the mysql_scheduler.create() service, it creates a new scheduled task instance to add to the queue, which signals the semaphore of the background thread. When the caller invokes destroy() and passes in the handle it received ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
The file is created on the server host, so you must have the FILE privilege to use this syntax. To create the resulting file on some other host, SELECT ... Note Any file created by INTO OUTFILE or INTO DUMPFILE is owned by the operating system user ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
You cannot use FOR UPDATE as part of the SELECT in a statement such as CREATE TABLE new_table SELECT ... (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
In such cases, you can use the audit2allow utility to create custom policies to permit access where it is required. The typical method for creating custom policies is to change the SELinux mode to permissive, identify access denial messages in the ... Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file. For non-Windows platforms, no default option file is created during either the server installation or ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. A consequence of this is that SET member values should not themselves contain commas. SET ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. The other storage engines support non-SPATIAL indexes, as described in Section 15.1.15, “CREATE INDEX Statement”.