mysql(rpm包)安装

一、环境介绍

[root@node1 ~]# cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)

二、安装部署

(1)下载软件包

根据需要到官网下载软件包https://downloads.mysql.com/archives/community/，我这里下载的是5.7
[root@node1 ~]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
[root@node1 mysql]# tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar									==>解压软件包
mysql-community-libs-5.7.22-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
mysql-community-test-5.7.22-1.el7.x86_64.rpm
mysql-community-server-5.7.22-1.el7.x86_64.rpm
mysql-community-client-5.7.22-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
mysql-community-devel-5.7.22-1.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm

(2)卸载旧数据库

[root@node1 ~]# yum install -y libaio
[root@node1 ~]#  rpm -qa | grep mysql																											==>查看是否安装mysql/mariadb
[root@node1 ~]#  rpm -qa | grep mariadb
如果存在可以用rpm -e --nodeps {-file-name}进行卸载									

(3)正式安装

按照依赖关系依次安装rpm包 依赖关系依次为common→libs→client→server
[root@node1 mysql]# rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
[root@node1 mysql]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
[root@node1 mysql]# rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
[root@node1 mysql]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
启动数据库，并查看状态
[root@node1 mysql]# systemctl start mysqld
[root@node1 mysql]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 五 2021-12-10 14:52:38 CST; 7s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 3290 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 3210 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 3294 (mysqld)
    Tasks: 27
   Memory: 337.5M
   CGroup: /system.slice/mysqld.service
           └─3294 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

(4)创建用户并登录数据库

查找临时密码并修改密码
[root@node1 mysql]# grep 'temporary password' /var/log/mysqld.log
2021-12-10T06:52:36.182549Z 1 [Note] A temporary password is generated for root@localhost: ?>yut7-,SXji(临时密码)
[root@node1 mysql]# mysql -u root -p
Enter password:
mysql> alter user root@localhost identified by 'Test@123';																		==>修改root密码
Query OK, 0 rows affected (0.00 sec)

(5)遇到的问题

需要rpm -qa | grep mariadb
将rpm -e --nodeps mariadb-libs*卸载
[root@node1 mysql]# rpm -ivh mysql-community*
警告：mysql-community-client-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
	mariadb-libs 被 mysql-community-libs-5.7.22-1.el7.x86_64 取代
	mariadb-libs 被 mysql-community-libs-compat-5.7.22-1.el7.x86_64 取代
	perl(JSON) 被 mysql-community-test-5.7.22-1.el7.x86_64 需要