MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 321 to 330 of 331 total results

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html

If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...

8.4.3.2 Password Validation Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html

This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...

8.4.3 The Password Validation Component

https://dev.mysql.com/doc/refman/8.0/en/validate-password.html

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...

7.6.6.3 Using Version Tokens

https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html

Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL ...

27.5.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

15.6.5.8 WHILE Statement

https://dev.mysql.com/doc/refman/8.0/en/while.html

[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...

2.3.4.2 Creating an Option File

https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html

If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file. For options that are used every time the server starts, you may find it most convenient to use an option file ...

2.3.6 Windows Postinstallation Procedures

https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html

GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...

5.3.4.6 Working with NULL Values

https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html

The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...

15.3.8.3 Restrictions on XA Transactions

https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html

XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as ...

Displaying 321 to 330 of 331 total results