準(zhǔn)備工作：
刪除mariadb
$ rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
## 上一步查出來的文件名榆俺，直接復(fù)制下來就OK歇拆，刪除maridab
$ rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
刪除遺留目錄
ls /etc/my.cnf
ll /var/lib/mysql/
rm –rf /etc/my.cnf
rm –rf /var/lib/mysql/
安裝mysql
1痴晦、下載mysql5.7的rpm安裝包
- 下載地址：https://downloads.mysql.com/archives/community/
我選擇下面紅框內(nèi)的版本：
image.png
下載后的文件如下：
image.png
2景埃、我是使用xshell連接服務(wù)器块茁，使用lrzsz命令上傳唇兑。
3厦坛、查看linux上是否已經(jīng)安裝了mysql,有則卸載。
一般centos7默認(rèn)安裝了mariadb,這里把它卸載棠众。
4琳疏、安裝mysql5.7所需要的依賴
[root@ecs-e50ota-0009 opt]# yum install -y libaio
[root@ecs-e50ota-0009 opt]# yum install -y perl
[root@ecs-e50ota-0009 opt]# yum install -y net-tools
5、解壓mysql5.7安裝包
[root@ecs-e50ota-0009 opt]# tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar
解壓后如下：
[root@ecs-e50ota-0009 opt]# tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar
mysql-community-common-5.7.30-1.el7.x86_64.rpm
mysql-community-server-5.7.30-1.el7.x86_64.rpm
mysql-community-test-5.7.30-1.el7.x86_64.rpm
mysql-community-client-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-5.7.30-1.el7.x86_64.rpm
mysql-community-libs-5.7.30-1.el7.x86_64.rpm
mysql-community-devel-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.30-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.30-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.30-1.el7.x86_64.rpm
6闸拿、安裝msyql5.7空盼，按照順序一步一步安裝。
[root@ecs-e50ota-0009 opt]# rpm -ivh mysql-community-common-5.7.30-1.el7.x86_64.rpm
[root@ecs-e50ota-0009 opt]# rpm -ivh mysql-community-libs-5.7.30-1.el7.x86_64.rpm
[root@ecs-e50ota-0009 opt]# rpm -ivh mysql-community-client-5.7.30-1.el7.x86_64.rpm
[root@ecs-e50ota-0009 opt]# rpm -ivh mysql-community-server-5.7.30-1.el7.x86_64.rpm
7新荤、查看mysql啟動狀態(tài)揽趾，一般是沒有啟動
[root@ecs-e50ota-0009 opt]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: inactive (dead)
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
[root@ecs-e50ota-0009 opt]#
8、啟動mysql active(running)代表啟動成功
[root@ecs-e50ota-0009 opt]# systemctl start mysqld
[root@ecs-e50ota-0009 opt]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2021-07-30 17:11:36 CST; 1min 6s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 19077 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 19019 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 19080 (mysqld)
CGroup: /system.slice/mysqld.service
└─19080 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Jul 30 17:11:25 ecs-e50ota-0009.novalocal systemd[1]: Starting MySQL Server...
Jul 30 17:11:36 ecs-e50ota-0009.novalocal systemd[1]: Started MySQL Server.
[root@ecs-e50ota-0009 opt]#
9苛骨、修改默認(rèn)密碼
查看臨時密碼：得知臨時密碼就是如下：m3XR<L/)k<Pk
[root@ecs-e50ota-0009 opt]# grep password /var/log/mysqld.log
2021-07-30T09:11:33.741759Z 1 [Note] A temporary password is generated for root@localhost: m3XR<L/)k<Pk
用臨時密碼登錄mysql
[root@ecs-e50ota-0009 opt]# mysql -uroot -p
修改成新的密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abcd@1234';
10篱瞎、 開啟遠(yuǎn)程連接,允許遠(yuǎn)程連接數(shù)據(jù)庫
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Abcd@1234' WITH GRANT OPTION;
備注：mysql 8版本，此命令有變化：需要先創(chuàng)建用戶痒芝，然后再授權(quán)
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON . TO 'root'@'%';
11俐筋、配置mysql的配置文件my.cnf(用默認(rèn)的也行)
打開配置文件my.cnf
[root@localhost src]# vi /etc/my.cnf
在[mysqld]下面配置幾行
lower_case_table_names=1 #配置表名不區(qū)分大小寫 1：不區(qū)分大小寫 0：區(qū)分大小寫 這行必須配置 默認(rèn)表名是區(qū)分大小寫的，不利于開發(fā)
character-set-server=utf8 #設(shè)置為默認(rèn)編碼為utf8
init_connect='SET NAMES utf8'
max_connections=1024 #設(shè)置最大連接數(shù)
重啟mysql 重啟配置才能生效
[root@localhost src]# service mysqld restart
12严衬、關(guān)閉防火墻澄者。
至此，centos7下安裝mysql5.7完畢.
