centos7安装mysql5.7（rpm安装）

2021-07-30 本文已影响0人彩色的炮灰

准备工作：
删除mariadb

$ rpm -qa|grep mariadb         
mariadb-libs-5.5.56-2.el7.x86_64
## 上一步查出来的文件名，直接复制下来就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/
我选择下面红框内的版本：
image.png
下载后的文件如下：
image.png

2、我是使用xshell连接服务器，使用lrzsz命令上传。

image.png

3、查看linux上是否已经安装了mysql,有则卸载。
一般centos7默认安装了mariadb,这里把它卸载。

image.png

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启动状态，一般是没有启动

[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、修改默认密码
查看临时密码：得知临时密码就是如下：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、开启远程连接,允许远程连接数据库

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

11、配置mysql的配置文件my.cnf(用默认的也行)
打开配置文件my.cnf

[root@localhost src]# vi /etc/my.cnf
在[mysqld]下面配置几行
lower_case_table_names=1 #配置表名不区分大小写 1：不区分大小写 0：区分大小写这行必须配置默认表名是区分大小写的，不利于开发
character-set-server=utf8 #设置为默认编码为utf8
init_connect='SET NAMES utf8'
max_connections=1024 #设置最大连接数
重启mysql 重启配置才能生效
[root@localhost src]# service mysqld restart

12、关闭防火墙。
至此，centos7下安装mysql5.7完毕.

centos7安装mysql5.7（rpm安装）

安装mysql

猜你喜欢

热点阅读