1.先下载mysql安装包
https://dev.mysql.com/downloads/mysql/5.7.html
选择你需要的版本下载(我这边下载的是)。
2.上传你下载的安装包上传到相应的服务器上
3.解压缩相对应的安装包
tar xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar
4.centos7版本需要相应的lib包
如果服务器有外网可以直接yum安装
yum install libaio-* -y
如果没有外网可以挂载镜像搭建本地yum源进行安装
5.删除centos7本身自带的mariadb版本库
rpm -qa|grep mariadb 查看本机自带的mariadb版本
如果有相应的版本卸载安装
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
rpm -e --nodeps mariadb-5.5.64-1.el7.x86_64
6.解压出来的包必须 按照顺序进行安装
rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm
7.安装完成后,启动数据库
systemctl start mysqld
8.设置开机启动
systemctl enable mysqld
9.首次登陆使用自动生成的密码
10.mysql修改密码
登陆数据库修改初始密码
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user ‘root’@‘localhost’ identified by ‘zabbix’;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.10 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> alter user ‘root’@‘localhost’ identified by ‘zabbix’;
Query OK, 0 rows affected (0.07 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
至此本次安装mysql5.7版本结束