安装前的准备

1、删除系统自带的Mariadb

// 查找 rpm -qa | grep mariadb // 删除 rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

2、安装mysql5.7所需要的依赖

yum install libaio perl net-tools

3、下载mysql5.7的rpm安装包（自行百度）

mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar

安装MySQL

1、上传MySQL rpm安装包到服务器 2、解压MySQL

tar xvf mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar

3、安装MySQL

rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm --nodeps --force

注：server的安装必须添加 --nodeps --force 否则可能会出现类似下面的错误

error: Failed dependencies: libaio.so.1 is needed by MySQL-server-5.5.31-2.el6.i686 libaio.so.1(LIBAIO_0.1) is needed by MySQL-server-5.5.31-2.el6.i686 libaio.so.1(LIBAIO_0.4) is needed by MySQL-server-5.5.31-2.el6.i686

4、MySQL服务的相关操作

// 查看状态|启动|停止 service mysqld status|start|stop

5、查看临时密码

grep password /var/log/mysqld.log

A temporary password is generated for root@localhost: K3D*/2cdAc78

注：最后的就是临时密码

6、修改密码

// 登录 mysqld -uroot -p // 修改root的密码 set password = password(“ACDE323#$@CDaa”); flash privileges;

7、开启远程连接,允许远程连接数据库

GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘ACDE323#$@CDaa’ WITH GRANT OPTION;

8、配置mysql的配置文件my.cnf

[client] default-character-set = utf8 [mysql] default-character-set = utf8 [mysqld] lower_case_table_names=1 #配置表名不区分大小写 1：不区分大小写 0：区分大小写 这行必须配置 默认表名是区分大小写的，不利于开发 character-set-server=utf8 #设置为默认编码为utf8 init_connect='SET NAMES utf8' max_connections=1024 #设置最大连接数

9、防火墙开启端口

systemctl stop firewalld