1 $ wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
1 $ yum -y install mysql57-community-release-el7-10.noarch.rpm
1 $ yum -y install mysql-community-server
1 $ systemctl start mysqld.service
1 grep "password" /var/log/mysqld.log
1 > show VARIABLES like "%password%"
2 +---------------------------------------+---------+
3 | Variable_name | Value |
4 |---------------------------------------+---------|
5 | default_password_lifetime | 0 |
6 | disconnect_on_expired_password | ON |
7 | log_builtin_as_identified_by_password | OFF |
8 | mysql_native_password_proxy_users | OFF |
9 | old_passwords | 0 |
10 | report_password | |
11 | sha256_password_proxy_users | OFF |
12 | validate_password_dictionary_file | |
13 | validate_password_length | 8 |
14 | validate_password_mixed_case_count | 1 |
15 | validate_password_number_count | 1 |
16 | validate_password_policy | MEDIUM |
17 | validate_password_special_char_count | 1 |
18 +---------------------------------------+---------+
介绍几个主要的:
validate_password_number_count | 参数是密码中至少含有的数字个数,当密码策略是MEDIUM或以上时生效。 |
---|---|
validate_password_special_char_count | 参数是密码中非英文数字等特殊字符的个数,当密码策略是MEDIUM或以上时生效。 |
validate_password_mixed_case_count | 参数是密码中英文字符大小写的个数,当密码策略是MEDIUM或以上时生效。 |
validate_password_length | 参数是密码的长度,这个参数由下面的公式生成 |
1 # 更改密码长度
2 set global validate_password_length=0;
3
4 # 更改数字个数
5 set global validate_password_number_count=0;
6
7 # 更改大小写字母个数
8 set global validate_password_mixed_case_count=0;
9
10 # 更改特殊字符个数
11 set global validate_password_special_char_count=0;
1 ALTER USER 'root'@'localhost' IDENTIFIED BY 'Your New Pssword';
1 grant all privileges on *.* to 'root'@'You IP or ALL %' identified by 'Your Password' with grant option;
1 flush privileges; # 刷新权限
在 [mysql] 之前插入下面两行
1 [client]
2 default-character-set=utf8
在 socket 之后插入下面两行:
1 character-set-server=utf8
2 collation-server=utf8_general_ci
transaction_isolation = READ-COMMITTED
将其上面的放入 my.cnf 或者 my.ini 文件中
做完上面的可以重启下Mysql服务。