Linux环境部署MySQL

LINUX环境下部署MySQL

MySQL官网：https://www.mysql.com/
MySQL是一种关系型数据库管理系统，所使用的 SQL 语言是用于访问数据库的最常用标准化语言。MySQL 软件采用了双授权政策，分为社区版和商业版，由于其体积小、速度快、总体拥有成本低，尤其是开放源码这一特点。本文采用社区版进行测试学习MySQL。

一、准备安装包

在该目录下再创建一个文件夹，并且将安装包解压到该文件夹中

[root@test01 soft]# ls
mysql-8.0.36-1.el7.x86_64.rpm-bundle.tar
# 在当前目录下（mysql）下创建一个 mysql-8.0.26 文件夹
[root@test01 soft]# mkdir mysql-8.0.36 
# 解压安装包到该目录下
[root@test01 soft]# tar -xvf mysql-8.0.36-1.el7.x86_64.rpm-bundle.tar -C mysql-8.0.36
1
2
3
4
5
6

解压完成之后可以切换到 mysql-8.0.36 目录下查看解压后的文件

[root@test01 mysql-8.0.36]# ls
mysql-community-client-8.0.36-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.36-1.el7.x86_64.rpm
mysql-community-common-8.0.36-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.36-1.el7.x86_64.rpm
mysql-community-devel-8.0.36-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.36-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm
mysql-community-libs-8.0.36-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.36-1.el7.x86_64.rpm
mysql-community-server-8.0.36-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.36-1.el7.x86_64.rpm
mysql-community-test-8.0.36-1.el7.x86_64.rpm
1
2
3
4
5
6
7
8
9
10
11
12
13

二、安装RPM依赖包

解压后得到的文件都是RPM文件，需要用到RPM包资源管理器相关的指令安装RPM的安装包，安装执行RPM安装包需要一些插件，因为MySQL里面有部分RPM的安装依赖于该插件。

[root@test01 mysql-8.0.36]# yum -y install libaio perl net-tools
[root@test01 mysql-8.0.36]# yum install openssl-devel
1
2

三、安装MySQL的RPM包

安装完该插件之后，依次执行以下命令安装这些RPM包。

[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-common-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-common-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-common-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-client-plugins-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-client-plugins-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-client-plugins-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-libs-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-libs-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-libs-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-libs-compat-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-libs-compat-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-libs-compat-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-devel-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-devel-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-devel-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-client-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-client-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
	软件包 mysql-community-client-8.0.36-1.el7.x86_64 已经安装
[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-server-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-server-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
错误：依赖检测失败：
	mysql-community-icu-data-files = 8.0.36-1.el7 被 mysql-community-server-8.0.36-1.el7.x86_64 需要
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

出现错误信息，要解决这个问题，需要先安装缺失的ICU数据文件。

[root@test01 mysql-8.0.36]# yum install mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm
已加载插件：fastestmirror, langpacks
正在检查 mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm: mysql-community-icu-data-files-8.0.36-1.el7.x86_64
mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm 将被安装
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql-community-icu-data-files.x86_64.0.8.0.36-1.el7 将被 安装
--> 解决依赖关系完成
http://mirrors.aliyun.com/centos-altarch/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
===============================================================================================
 Package         架构   版本         源                                                   大小
===============================================================================================
正在安装:
 mysql-community-icu-data-files
                 x86_64 8.0.36-1.el7 /mysql-community-icu-data-files-8.0.36-1.el7.x86_64 3.9 M

事务概要
===============================================================================================
安装  1 软件包

总计：3.9 M
安装大小：3.9 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
警告：RPM 数据库已被非 yum 程序修改。
  正在安装    : mysql-community-icu-data-files-8.0.36-1.el7.x86_64                         1/1 
  验证中      : mysql-community-icu-data-files-8.0.36-1.el7.x86_64                         1/1 

已安装:
  mysql-community-icu-data-files.x86_64 0:8.0.36-1.el7                                         

完毕！
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

安装缺失的ICU文件后重新安装mysql-community-server-8.0.36-1.el7.x86_64.rpm包。

[root@test01 mysql-8.0.36]# rpm -ivh mysql-community-server-8.0.36-1.el7.x86_64.rpm
警告：mysql-community-server-8.0.36-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID a8d3785c: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-server-8.0.36-1.e################################# [100%]
1
2
3
4
5

四、启动MySQL服务

在Linux中MySQL安装好了之后系统会自动的注册一个服务，服务名称叫做 mysqld，所以可以通过以下命令操作MySQL：

• 启动MySQL服务：systemctl start mysqld
• 重启MySQL服务：systemctl restart mysqld
• 关闭MySQL服务：systemctl stop mysqld

# 启动mysql服务
[root@panweidb mysql-8.0.36]# systemctl start mysqld
Redirecting to /bin/systemctl start mysqld.service
1
2
3

RPM安装MySQL会自动生成一个随机密码，可以在/var/log/mysqld.log这个文件中查找密码。

[root@panweidb mysql-8.0.36]# cat /var/log/mysqld.log | grep password
2024-04-18T09:24:14.608802Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lpOagaL2hu;d
1
2

五、连接MySQL服务

[root@test01 mysql-8.0.36]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.36

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

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> 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

为了方便后期使用需要更改初始密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@123';
Query OK, 0 rows affected (0.01 sec)
1
2