Contos7部署Mysql

部署mysql5.7

1、先把postfix 和mariadb-libs卸载掉，不然的会有依赖包冲突：

rpm -e postfix mariadb-libs

卸载

yum remove mysql-libs

2、安装mysql的依赖net-tools和 perl

yum -y install net-tools perl

需要装备好mysql的安装包

3、安装mysql-common包：

rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm

4、安装mysql-libs包：

rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm

5、安装mysql-client包；

rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm

6、安装mysql-server包

rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

安装MySQL服务器时会提示依赖包libaio.so.1没有安装，错误提示如下：

error: Failed dependencies: 
libaio.so.1()(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64

需要使用yum命令快速安装依赖包libaio，运行如下命令：

yum install libaio

7、设置开机启动：

systemctl enable mysqld

8、启动MySql服务

systemctl start mysqld

9、由于MySQL5.7安装好后会给root用户分配一个临时密码，所以我们先查看临时密码

grep 'temporary password' /var/log/mysqld.log

2018-06-01T19:40:08.341478Z 1 [Note] A temporary password is generated for root@localhost: Ct<pX.k7S(=w

冒号后面的就是root用户的临时密码：Ct<pX.k7S(=w

10、使用临时密码登录

mysql -u root -p

输入密码：Ct<pX.k7S(=w

11、设置root的密码

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'WolfCode_2017';

*注意：mysql5.7增加了安全级别，密码********必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。*

11、开放远程登录权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'WolfCode_2017'  WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

12、开放mysql的3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

如果出现乱码:

在链接地址栏后添加useUnicode=true&characterEncoding=utf-8