SET NAMES charset_name SET NAMES default_character_set SET PASSWORD SET PASSWORD ... = PASSWORD() SET PERSIST SET PERSIST_ONLY 5959 Section 6.3.1, “Configuring MySQL to Use Encrypted Connections” Section 4.2.8, “Connection Compression Control” Section 6.4.2.1, “Connection-Control Plugin Installation” Section 5.4.2.1, “Error Log Configuration” Section 6.4.1.7, “LDAP Pluggable Authentication” Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables” Section 6.2.15, “Password Management” Section 27.12.14.1, “Performance Schema persisted_variables Table” Section 5.1.9.3, “Persisted System Variables” Section 6.2.12, “Privilege Restriction Using Partial Revokes” Section 6.2.2, “Privileges Provided by MySQL” Section 5.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)” Section 5.1.8, “Server System Variables” Section 13.7.6.1, “SET Syntax for Variable Assignment” Section 5.1.9.1, “System Variable Privileges” Section 6.4.7.3, “Using MySQL Enterprise Firewall” Section 4.2.2.2, “Using Option Files” Section 6.2.10, “Using Roles” Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables” Section 5.1.9.3, “Persisted System Variables” Section 1.3, “What Is New in MySQL 8.0” Section 6.2.3, “Grant Tables” Section 12.16, “Information Functions” Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables” Section 6.2.15, “Password Management” Section 6.4.3.2, “Password Validation Options and Variables” Section 6.1.2.3, “Passwords and Logging” Section 6.2.2, “Privileges Provided by MySQL” Section 17.5.1.39, “Replication and Variables” Section 17.5.1.8, “Replication of CURRENT_USER()” Resetting the Root Password: Generic Instructions Section 6.2.16, “Server Handling of Expired Passwords” Section 5.1.8, “Server System Variables” Section 13.7.1.10, “SET PASSWORD Statement” Section 13.7.6, “SET Statements” Section 6.2.4, “Specifying Account Names” Section 13.3.3, “Statements That Cause an Implicit Commit” Section 6.4.3, “The Password Validation Component” Section 6.2.13, “When Privilege Changes Take Effect” Section 4.5.4, “mysqldump — A Database Backup Program” Section 4.5.6, “mysqlpump — A Database Backup Program” Section 4.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”