CentOS 7.2下MySQL的安装与相关配置

wget http://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm

sudo yum localinstall platform-and-version-specific-package-name.rpm

shell> yum repolist all | grep mysql

sudo yum install mysql-community-server

sudo systemctl start mysqld

systemctl status mysqld

mysql_secure_installation

sudo grep 'temporary password' /var/log/mysqld.log

SHOW VARIABLES LIKE 'validate_password%';

+--------------------------------------+--------+
| Variable_name            | Value |
+--------------------------------------+--------+
| validate_password_dictionary_file  |    |
| validate_password_length       | 8   |
| validate_password_mixed_case_count  | 1   |
| validate_password_number_count    | 1   |
| validate_password_policy       | MEDIUM |
| validate_password_special_char_count | 1   |
+--------------------------------------+--------+

mysql> SET GLOBAL validate_password_policy = LOW;
mysql> SET GLOBAL validate_password_length = 6;
mysql> SET GLOBAL validate_password_number_count = 0;
mysql> SET GLOBAL validate_password_mixed_case_count = 0;
mysql> SET GLOBAL validate_password_special_char_count = 0;