Mysql--mysql 5.7 New features

Increased security

1.mysql.user adds a column of non-empty plugin, set to a null value to invalidate the account. Plugin's mysql_old_password改为 Mysql_native_password. MySQL has removed support for Mysql_old_password.

2.DBA can set the account expiration date.

3.DBA can lock and unlock accounts.

4. Make it easier to use secure connections. Version of MySQL server compiled with OpenSSL, which automatically generates RSA certificates and keys at startup.

5.MySQL is deployed by default with Mysqld--initialize, which is more secure.  

5.1 When installing, create only one account ' root ' @ ' localhost ', automatically generate a random password and the password is expired. The MySQL administrator must connect root as using the random password and assign a new password. (The server writes the random password to the error log.)

Mysql--mysql 5.7 New features