MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 20 of 218 total results

6.1.2.2 Administrator Guidelines for Password Security

https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html

Database administrators should use the following guidelines to keep passwords secure. MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. See Section 6.2.11, ...

6.4.3.1 Password Validation Plugin Installation

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

This section describes how to install the validate_password password-validation plugin. Note If you installed MySQL 5.7 using the MySQL Yum repository, MySQL SLES Repository, or RPM packages provided by Oracle, validate_password is enabled by ...

6.1.2 Keeping Passwords Secure

https://dev.mysql.com/doc/refman/5.7/en/password-security.html

The following sections provide guidelines that enable end users and administrators to keep these passwords secure and avoid exposing them. There is also a discussion of how MySQL uses password hashing internally and of a plugin that you can use to ...

6.4.1.3 Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin

https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html

If the plugin column is empty, the server authenticates the account as follows: Before MySQL 5.7, the server uses the mysql_native_password or mysql_old_password plugin implicitly, depending on the format of the password hash in the Password column.

B.3.3.2 How to Reset the Root Password

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you know the root ...The following sections provide instructions for Windows and Unix and Unix-like systems, as well as generic instructions that apply to any ...

6.2.1 Account User Names and Passwords

https://dev.mysql.com/doc/refman/5.7/en/user-names.html

An account may also have authentication credentials such as a password. There are several distinctions between the way user names and passwords are used by MySQL and your operating system: User names, as used by MySQL for authentication purposes, ...

6.4.1.7 PAM Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html

PAM enables a system to use a standard interface to access various kinds of authentication methods, such as traditional Unix passwords or an LDAP directory. For information about the mysql_clear_password plugin, see Section 6.4.1.6, “Client-Side ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...

5.1.7 Server System Variables

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

For more information about SSL file autogeneration, including file names and characteristics, see Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL” The sha256_password_auto_generate_rsa_keys system variable is related but ... The MySQL server maintains many system variables that affect its ...

13.7.1.2 CREATE USER Statement

https://dev.mysql.com/doc/refman/5.7/en/create-user.html

[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... It enables authentication, SSL/TLS, resource-limit, and password-management properties to be established for new ...

13.7.1.1 ALTER USER Statement

https://dev.mysql.com/doc/refman/5.7/en/alter-user.html

Displaying 11 to 20 of 218 total results