Linux通过rpm包安装mysql5.7.22

准备工作：
1.首先登陆mysql官网下载页面
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
2.选择相应的选项并下载rpm包
Select Version:5.7.22
Select Operating System:Red Hat Enterprise Linux / Oracle Linux
Select OS Version:Red Hat Enterprise Linux 7/ Oracle Linux 7 (x86，64-bit)
选择完毕在下方选择mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar下载
3.安装系统

[root@zk1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@zk1 ~]#

1.上传并解压rpm包

[root@zk1 opt]#mkdir mysql
[root@zk1 opt]#mv mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar ./mysql
[root@zk1 opt]#cd mysql/
[root@zk1 mysql]#tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
[root@zk1 mysql]#ll
total 1168028
-rw-r--r-- 1 root root  598026240 Mar  5 10:44 mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
-rw-r--r-- 1 7155 31415  25106088 Mar  5 10:24 mysql-community-client-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    280800 Mar  5 10:24 mysql-community-common-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   3781636 Mar  5 10:24 mysql-community-devel-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  46742952 Mar  5 10:24 mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  24078476 Mar  5 10:24 mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 129955496 Mar  5 10:24 mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2239868 Mar  5 10:24 mysql-community-libs-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2116356 Mar  5 10:24 mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  55743828 Mar  5 10:24 mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 172992596 Mar  5 10:25 mysql-community-server-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  15255560 Mar  5 10:25 mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 119716756 Mar  5 10:25 mysql-community-test-5.7.22-1.el7.x86_64.rpm

2.删除maridb

[root@zk1 mysql]#rpm -qa | grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64
[root@zk1 mysql]#rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

3.由于有依赖关系，依次安装以下四个包

[root@zk1 mysql]#rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
[root@zk1 mysql]#rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
[root@zk1 mysql]#rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
[root@zk1 mysql]#rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.22-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.22-1.el7.x86_64
        net-tools is needed by mysql-community-server-5.7.22-1.el7.x86_64
        perl(Getopt::Long) is needed by mysql-community-server-5.7.22-1.el7.x86_64
        perl(strict) is needed by mysql-community-server-5.7.22-1.el7.x86_64

#依赖报错安装相应的包
[root@zk1 mysql]#yum install net-tools
[root@zk1 mysql]#yum install perl
#依赖包安装完成在继续安装刚才报错rpm包
[root@zk1 mysql]#rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

4.启动mysql

[root@zk1 mysql]#service mysqld start
#获取密码
[root@zk1 usr]#grep 'temporary password' /var/log/mysqld.log
2018-07-28T08:03:36.165230Z 1 [Note] A temporary password is generated for root@localhost: Zc?H2OJE65ub
#登陆mysql
[root@zk1 usr]#mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
#更改root密码
mysql> set password=password('tianpy5@');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
#由于密码简单，不符合策略，改为包含字母和数字，大小写，特殊字符的字符串
mysql>  set password=password('Tian_0801');
#授权访问
mysql> grant all privileges on *.* to root@'%' identified by 'Tian_0801';
mysql> flush privileges;

5.配置文件修改字符编码

[root@zk1 ~]# cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
character_set_server=utf8
collation-server=utf8_general_ci

[mysql]
default-character-set=utf8

[client]
default-character-set=utf8

6.设置开机自启动，并重启mysql

[root@zk1 ~]# systemctl enable mysqld
[root@zk1 ~]# systemctl restart mysqld