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/restart.html
To alleviate this, starting the server with --gdb suppresses forking, in addition to its other actions done to set up a debugging environment. One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. If the connection between the client and the server goes through an untrusted network, and ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html
This option is dynamic, but should be set only by server. The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system ...
https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source server. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql ...It requires ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
When this manual refers to “strict mode,” it means a mode with either or both STRICT_TRANS_TABLES or STRICT_ALL_TABLES enabled. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers.
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
To determine whether your system supports symbolic links, check the value of the have_symlink system variable using this statement: SHOW VARIABLES LIKE 'have_symlink'; The handling of symbolic links for MyISAM tables works as follows: In the data ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
If this is not desired, you can drop the sys schema manually after initialization if it is unneeded. Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. The MySQL upgrade procedure ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
This applies to the system tables and objects in other schemas. This step upgrades: The data dictionary tables in the mysql schema. The data dictionary upgrade (step 1) is the responsibility of the server, which performs this task as necessary at ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
This component exposes system variables that enable you to configure password policy, and status variables for component monitoring. For instructions on using the plugin form of validate_password, see The Password Validation Plugin, in MySQL 5.7 ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
In this case, the view is stored in a temporary table and thus you are not really selecting from the table in a subquery and modifying it at the same time. (This is another reason you might wish to force MySQL to use the temptable algorithm by ...