CentOS7下使用yum安装mysql5.7.24,亲试可用。
1.卸载,如果安装过mysql,先停掉mysql进程;没有安装过的直接跳过这一步。
//查找mysql进程
netstat -antp
//杀死mysql进程
pkill -9 mysqld
//查找包含mysql的安装组件
rpm -qa|grep -i mysql
命令说明:
rpm 管理套件
-qa 使用询问模式,查询所有套件
grep 查找文件里符合条件的字符串
java 查找包含java字符串的文件
//用命令 yum -y remove,卸载不掉的用 rpm -ev
yum -y remove mysql-community-client-5.6.38-2.el7.x86_64
依次卸载mysql相关,直到查找不到包含mysql的相关的模块
2.下载mysql的repo源,并且安装
//切换到/usr/local/src/目录
cd /usr/local/src/
//从仓库下载mysql
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
//
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
//安装
yum -y install mysql-server
安装完成。
此时的默认配置文件路径:
配置文件:/etc/my.cnf
日志文件:/var/log/var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
3.修改配置文件my.cnf
//编辑my.cnf
vim /etc/my.cnf
my.cnf:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
4.启动mysql服务
//重启mysql服务
service mysqld restart
5.重置密码
//获取初始密码(temporary password)
grep "password" /var/log/mysqld.log
=========================================分割线===========================================
注意:mysql5.7.20 为了安全密码,默认不能在设置简单密码,必须包含大写字母,数字、符号
更改为简单密码的方法如下:
//查看msyql密码相关的几个全局参数配置:
mysql> select @@validate_password_policy;
+----------------------------+
| @@validate_password_policy |
+----------------------------+
| MEDIUM |
+----------------------------+
1 row in set (0.00 sec)
mysql> 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 |
+--------------------------------------+--------+
6 rows in set (0.08 sec)
参数说明:
validate_password_dictionary_file | 插件用于验证密码强度的字典文件路径。 |
validate_password_length | 密码最小长度,参数默认为8,它有最小值的限制,最小值为:validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count) |
validate_password_mixed_case_count | 密码至少要包含的小写字母个数和大写字母个数。 |
validate_password_number_count | 密码至少要包含的数字个数。 |
validate_password_policy | 密码强度检查等级,0/LOW、1/MEDIUM、2/STRONG。有以下取值: Policy Tests Performed 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 默认是1,即MEDIUM,所以刚开始设置的密码必须符合长度,且必须含有数字,小写或大写字母,特殊字符。 |
validate_password_special_char_count | 密码至少要包含的特殊字符数。 |
我们只需要如下修改配置就可以设置简单密码了:
//修改验证密码等级为0(LOW),只验证密码的长度
mysql> set global validate_password_policy=0;
//修改验证密码最小长度为4
mysql> set global validate_password_length=4;
//修改简单密码
mysql> set password for 'root'@'localhost' = password('1234')
简单密码修改完毕。
最后,安装结束。