Centos7安装MySql 5.7

1. 下载上传解压

下载: mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar

访问下面的链接，然后点击下图圈住的位置

MySQL :: Begin Your Download

将安装包上传到linux服务器

解压到安装目录如：/usr/local/software/mysql

tar -xvf mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar - C /usr/local/software/mysql 

查看解压后的文件

cd /usr/local/software/mysql 
ls

2. 安装

将下面的版本号改为实际解压后的版本号

是依次执行，不要乱了顺序，因为它们之间有依赖关系,依次执行命令：

sudo rpm -ivh --force mysql-community-common-5.7.16-1.el6.x86_64.rpm 
sudo rpm -ivh --force mysql-community-libs-5.7.16-1.el6.x86_64.rpm
sudo rpm -ivh --force mysql-community-client-5.7.16-1.el6.x86_64.rpm
sudo rpm -ivh --force mysql-community-server-5.7.16-1.el6.x86_64.rpm

如果执行报错,如下图,则参考第3步,第4步

3. 卸载冲突的rpm组件(可选)

在我们安装mysql相关组件的时候，如果不将此冲突的组件删除掉，我们是安装不成功的,

# 安装mysql组件时出现的依赖错误

error: Failed dependencies:

mysql-community-common(x86-64) >= 5.7.9is needed by mysql-community-libs-5.7.19-1.el7.x86_64 mariadb-libs is obsoleted by mysql-community-libs-5.7.19-1.el7.x86_64

# 卸载mariadb-libs时出现的依赖错误

error: Failed dependencies:

libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64 libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64

查看postfix和mariadb-libs

[root@localhost software]# rpm -qa | grep postfix 
postfix-2.10.1-6.el7.x86_64 
[root@localhost software]# rpm -qa | grep mariadb
 mariadb-libs-5.5.52-1.el7.x86_64

卸载postfix和mariadb-libs

[root@localhost software]# rpm -ev postfix-2.10.1-6.el7.x86_64
Preparing packages... postfix-2:2.10.1-6.el7.x86_64 
[root@localhost software]# rpm -ev mariadb-libs-5.5.52-1.el7.x86_64
Preparing packages... mariadb-libs-1:5.5.52-1.el7.x86_64

4. 安装依赖组件(可选)

安装msql-community-server-xxx的时候出现了下面的问题

[root@localhost software]# rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm  
warning: mysql-community-server-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
 error: Failed dependencies: 
/usr/bin/perl is needed by mysql-community-server-5.7.19-1.el7.x86_64 
libaio.so.1()(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64
 libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64 
libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64 
net-tools is needed by mysql-community-server-5.7.19-1.el7.x86_64 
perl(Getopt::Long) is needed by mysql-community-server-5.7.19-1.el7.x86_64 
perl(strict) is needed by mysql-community-server-5.7.19-1.el7.x86_64 
[root@localhost software]# 

由上面的错误可以看出我们需要安装相应的依赖

1. libaio

2. net-tools

3. perl

• 安装依赖

 yum -y install libaio 
 yum -y net-tools 
 yum -y perl 

5. 启动

 service mysqld start 

6. 修改root用户密码

启动后在vi /var/log/mysqld.log中获取root账户的初始密码

修改密码

连接mysql命令行,格式如下

mysql -h hostname -P port -u username -p password

用初始密码登录后，发现无论输出什么SQL都会出现一下错误：

mysql> alter user 'root'@'localhost' identified by 'newpassword';
mysql> flush privileges;

MySQL对用户密码安全性有所加强，所以设置的密码必须包含有数字，大写字母，小写字母，特殊符号，如果你设置的密码过于简单，会提示：

7. 配置数据库编码

下面我们看下数据库编码：

mysql> show variables like '%char%';

将character_set_server 设置为utf-8

如果你需要修改数据库编码则：

编辑 vi /etc/my.conf

在mysqld中增加

character_set_server=utf8
init_connect=’SET NAMES utf8’

如图:

保存，然后重启mysql：

service mysqld restart 

8. 开启远程连接

如果需要使用root账号远程访问mysql服务器，需要

连接mysql命令行执行下面的命令

注意：@Qyqcsglwyp123 为你root账号的密码，需要替换为

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '@Qyqcsglwyp123' WITH GRANT OPTION;
flush privileges;

9. 完成