1.在mysql官网查看压缩文件地址
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
2.安装新版mysql前,需将系统自带的mariadb-lib卸载
rpm -qa|grep mariadb mariadb-libs-5.5.60-1.el7_5.x86_64 输出包名 rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 卸载mariadb systemctl stop firewalld 临时关闭防火墙 systemctl disable firewalld 关闭防火墙永久性生效
3.下载安装包到 /usr/local/
yum install wget cd /usr/local/ wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
4.安装mysql需要的依赖库
yum install libaio yum -y install numactl.x86_64
5.安装MySQL
cd /usr/local/ tar -xf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz mv mysql-5.7.33-linux-glibc2.12-x86_64 mysql 创建mysql用户和用户组 useradd mysql id mysql 修改mysql文件夹所有文件和目录的所属人和所属组 cd mysql chown -R mysql . chgrp -R mysql . 创建数据存放的目录 mkdir data 进入到mysql的bin目录下,执行安装 cd bin/ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data 查看mysql的初始密码 cat /root/.mysql_secret 启动mysql cd ../support-files/ ./mysql.server start 设置mysql为自动启动 cd /usr/local/mysql cp support-files/mysql.server /etc/init.d/mysql chkconfig --add mysql chkconfig --list mysql 创建全局链接 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 修改密码 mysql -uroot -p SET PASSWORD = PASSWORD('root') ; 设置mysql数据库允许远程登录 GRANT ALL PRIVILEGES ON *.* TO root@'%' identified by 'root'; flush privileges; 查看MySQL安装路径 show variables like "%dir%"; show variables like "%port%";