MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 281 to 290 of 298 total results

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

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program ...

15.2.17 UPDATE Statement

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

where_condition is an expression that evaluates to true for each row to be updated. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the ...

3.13 Upgrade Troubleshooting

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

The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an ...

3.4 What the MySQL Upgrade Process Upgrades

https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html

This is true whether the server or mysql_upgrade performs the step. Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/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/8.0/en/using-encrypted-connections.html

This remains true until the next change to the system variables. 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, ...

7.1.9 Using System Variables

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

On the other hand, with SET you can assign a variable's value using an expression, which is not true when you set a variable at server startup. The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server ...

2.5.9 Managing MySQL Server with systemd

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

To suppress this automatic initialization behavior, specify the following line in the /etc/sysconfig/mysql file (create the file if it does not exist): NO_INIT=true Configuring Multiple MySQL Instances Using systemd This section describes how to ...

8.4.3.2 Password Validation Options and Variables

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

Assuming that is true, each substring of the password of length 4 up to 100 is compared to the words in the dictionary file. This section describes the system and status variables that validate_password provides to enable its operation to be ...

8.4.3 The Password Validation Component

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

This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy. The validate_password component serves to improve security by ...

Displaying 281 to 290 of 298 total results