一键安装mysql5.7及密码策略修改方法
程序员文章站
2022-11-11 12:57:43
一、一键安装mysql脚本
[root@uat01 ~]# cat installmysql01.sh
#!/bin/bash
#2018-10-13
#...
一、一键安装mysql脚本
[root@uat01 ~]# cat installmysql01.sh #!/bin/bash #2018-10-13 #旅行者-travel #1.安装wget yum -y install wget #2、下载mysql的yum源 url="https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm" wget $url -p /etc/yum.repos.d/ yum -y install yum-utils #如果没有该包,下边执行yum-config-manager不生效 yum -y install /etc/yum.repos.d/mysql80-community-release-el7-1.noarch.rpm if [ $? -eq 0 ];then rm -rf /etc/yum.repos.d/mysql80-community-release-el7-1.noarch* fi yum-config-manager --disable mysql80-community yum-config-manager --enable mysql57-community yum -y install mysql-community-server sleep 5 systemctl start mysqld systemctl enable mysqld systemctl status mysqld if [ $? -eq 0 ];then echo -e "install succefull" result="`grep 'temporary password' /var/log/mysqld.log`" p1="`echo $result |awk '{print $nf}'`" echo "数据库密码为:$p1" fi [root@uat01 ~]#
二、修改策略和密码
执行完以上脚本可以看到mysql的密码,如下方法登录修改策略,因为默认密码要求比较高,可以根据自己需求来决定是否更改策略:
install succefull 数据库密码为:9atr&ok>f;1k [root@uat01 ~]# mysql -uroot -p enter password: welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 2 server version: 5.7.23 copyright (c) 2000, 2018, oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help;' or '\h' for help. type '\c' to clear the current input statement. mysql> set global validate_password_policy=0; query ok, 0 rows affected (0.00 sec) mysql> set global validate_password_length=4; query ok, 0 rows affected (0.00 sec) mysql> alter user 'root'@'localhost' identified by 'yanglt123.'; query ok, 0 rows affected (0.00 sec) mysql> flush privileges; query ok, 0 rows affected (0.00 sec) mysql> quit
三、数据库密码策略:
1、查看数据库策略:
因为上文已经将 validate_password_length 值改为4,所以下文显示为4,默认情况下为8
[root@uat01 ~]# mysql -uroot -p ..... server version: 5.7.23 mysql community ...... mysql> show variables like 'validate_password%'; +--------------------------------------+-------+ | variable_name | value | +--------------------------------------+-------+ | validate_password_check_user_name | off | | validate_password_dictionary_file | | | validate_password_length | 4 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | low | | validate_password_special_char_count | 1 | +--------------------------------------+-------+ 7 rows in set (0.00 sec) mysql>
2、各项值说明
validate_password_policy:密码安全策略,默认medium策略
策略 | 检查规则 |
0 or low | length |
1 or medium | length; numeric, lowercase/uppercase, and special characters |
2 or strong | length; numeric, lowercase/uppercase, and special characters; dictionary file |
validate_password_dictionary_file:密码策略文件,策略为strong才需要
validate_password_length:密码最少长度 ,测试发现最小值得为4。
validate_password_mixed_case_count:大小写字符长度,至少1个
validate_password_number_count :数字至少1个
validate_password_special_char_count:特殊字符至少1个
3、修改策略,跟上文第二操作一样
mysql> set global validate_password_policy=0; query ok, 0 rows affected (0.00 sec) mysql> set global validate_password_length=4; query ok, 0 rows affected (0.00 sec), mysql> flush privileges; query ok, 0 rows affected (0.00 sec)
4、修改简单密码测试
mysql> alter user 'root'@'localhost' identified by '1234'; #测试发现密码长度最少为4位 query ok, 0 rows affected (0.00 sec) mysql> flush privileges; query ok, 0 rows affected (0.01 sec) mysql> quit bye [root@uat01 ~]# mysql -p enter password: welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 5 server version: 5.7.23 mysql community server (gpl) copyright (c) 2000, 2018, oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help;' or '\h' for help. type '\c' to clear the current input statement. mysql>
总结
以上所述是小编给大家介绍的一键安装mysql5.7及密码策略修改方法,希望对大家有所帮助
上一篇: 秋季饮食五大原则 忌燥忌生冷多食蔬菜
下一篇: Mysql常用基准测试命令总结
推荐阅读
-
一键安装mysql5.7及密码策略修改方法
-
Ubuntu修改密码及密码复杂度策略设置方法
-
mysql5.7及mysql 8.0版本修改root密码的方法小结
-
【shell 每日一练7】一键安装mysql5.7,以及密码及策略修改
-
Mysql安装与配置调优及修改root密码的方法
-
Mysql5.7忘记root密码及mysql5.7修改root密码的方法_MySQL
-
Mysql5.7忘记root密码及mysql5.7修改root密码的方法_MySQL
-
一键安装mysql5.7及密码策略修改方法
-
mysql5.7及mysql 8.0版本修改root密码的方法小结
-
MySql5.7.11编译安装及修改root密码的方法小结_MySQL