MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 331 to 340 of 344 total results

https://dev.mysql.com/doc/refman/9.7/en/upgrade-troubleshooting.html

A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 9.7 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html

Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer ...

7.1.9 Using System Variables

https://dev.mysql.com/doc/refman/9.7/en/using-system-variables.html

The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/9.7/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.4.2 Password Validation Options and Variables

https://dev.mysql.com/doc/refman/9.7/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.4 The Password Validation Component

https://dev.mysql.com/doc/refman/9.7/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 ...

27.6.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/9.7/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/9.7/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.3.2 Creating an Option File

https://dev.mysql.com/doc/refman/9.7/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 ...

Displaying 331 to 340 of 344 total results