5种数据库服务器部署与安装
[root@MySQL ~]# dnf install mysql-server
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
Last metadata expiration check: 0:03:04 ago on Mon 30 Dec 2024 12:30:35 PM
CST.
Dependencies resolved.
============================================================================
=====================================================================
Package Architecture
Version Repository Size
============================================================================
=====================================================================
Installing:
mysql-community-server x86_64
8.4.3-1.el9 mysql-8.4-lts-community 50 M
Installing dependencies:
mysql-community-client x86_64
8.4.3-1.el9 mysql-8.4-lts-community 3.1 M
mysql-community-client-plugins x86_64
8.4.3-1.el9 mysql-8.4-lts-community 1.5 M
mysql-community-common x86_64
8.4.3-1.el9 mysql-8.4-lts-community 575 k
mysql-community-icu-data-files x86_64
8.4.3-1.el9 mysql-8.4-lts-community 2.3 M
mysql-community-libs x86_64
8.4.3-1.el9 mysql-8.4-lts-community 1.5 M
Transaction Summary
============================================================================
=====================================================================
Install 6 Packages
Total download size: 59 M
Installed size: 330 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): mysql-community-common-8.4.3-1.el9.x86_64.rpm
1.8 MB/s | 575 kB 00:00
(2/6): mysql-community-client-plugins-8.4.3-1.el9.x86_64.rpm
3.8 MB/s | 1.5 MB 00:00
(3/6): mysql-community-icu-data-files-8.4.3-1.el9.x86_64.rpm
13 MB/s | 2.3 MB 00:00
(4/6): mysql-community-libs-8.4.3-1.el9.x86_64.rpm
12 MB/s | 1.5 MB 00:00
(5/6): mysql-community-client-8.4.3-1.el9.x86_64.rpm
5.3 MB/s | 3.1 MB 00:00
(6/6): mysql-community-server-8.4.3-1.el9.x86_64.rpm
29 MB/s | 50 MB 00:01
----------------------------------------------------------------------------
Total
27 MB/s | 59 MB 00:02
MySQL 8.4 LTS Community Server
3.0 MB/s | 3.1 kB 00:00
Importing GPG key 0xA8D3785C:
Userid : "MySQL Release Engineering
Fingerprint: BCA4 3417 C3B4 85DD 128E C6D4 B7B3 B788 A8D3 785C
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing :
1/1
Installing : mysql-community-common-8.4.3-1.el9.x86_64
1/6
Installing : mysql-community-client-plugins-8.4.3-1.el9.x86_64
2/6
Installing : mysql-community-libs-8.4.3-1.el9.x86_64
3/6
Running scriptlet: mysql-community-libs-8.4.3-1.el9.x86_64
3/6
Installing : mysql-community-client-8.4.3-1.el9.x86_64
4/6
Installing : mysql-community-icu-data-files-8.4.3-1.el9.x86_64
5/6
Running scriptlet: mysql-community-server-8.4.3-1.el9.x86_64
6/6
Installing : mysql-community-server-8.4.3-1.el9.x86_64
6/6
Running scriptlet: mysql-community-server-8.4.3-1.el9.x86_64
6/6
Verifying : mysql-community-client-8.4.3-1.el9.x86_64
1/6
Verifying : mysql-community-client-plugins-8.4.3-1.el9.x86_64
2/6
Verifying : mysql-community-common-8.4.3-1.el9.x86_64
3/6
Verifying : mysql-community-icu-data-files-8.4.3-1.el9.x86_64
4/6
Verifying : mysql-community-libs-8.4.3-1.el9.x86_64
5/6
Verifying : mysql-community-server-8.4.3-1.el9.x86_64
6/6
Installed products updated.
Installed:
mysql-community-client-8.4.3-1.el9.x86_64 mysql-community-clientplugins-8.4.3-1.el9.x86_64 mysql-community-common-8.4.3-1.el9.x86_64
mysql-community-icu-data-files-8.4.3-1.el9.x86_64 mysql-community-libs-
8.4.3-1.el9.x86_64 mysql-community-server-8.4.3-1.el9.x86_64
Complete!
请注意：这里安装的是 8.4.3-1 这个最新版本。
2. 二进制本地
前三步与前面一样
4. 在上面的页面中点击【MySQL Community Server】链接进入下载页面，在列表选项中选择对应的选项，我们这里选择如下选项。
5. 单击第一项【RPM Bundle】条目后的【Download】按钮进入本地安装下载确认页面。
在确认页面中，点击确认链接进行下载，浏览器会自动下载该安装包，在下载完成后，可以将该安装包传送到Linux
操作系统中，也可以通过该链接直接在
Linux
操作系统中使用wget命令进行下载。下载完成后，我们使用以下命令进行解压。解压完成后，可以使用以下命令进行查看：
[root@MySQL ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.4/mysql-8.4.3-1.el9.x86_64.rpm-bundle.tar
[root@MySQL ~]# tar xf mysql-8.4.3-1.el9.x86_64.rpm-bundle.tar
[root@MySQL ~]# ll mysql-*
-rw-r--r--. 1 root root 926351360 Sep 18 23:32 mysql-8.4.3-
1.el9.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 3227147 Sep 18 22:56 mysql-community-client-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 26074383 Sep 18 22:56 mysql-community-clientdebuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 1553818 Sep 18 22:56 mysql-community-clientplugins-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 2886408 Sep 18 22:56 mysql-community-clientplugins-debuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 588325 Sep 18 22:56 mysql-community-common-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 5641071 Sep 18 22:57 mysql-community-debuginfo-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 18136250 Sep 18 22:57 mysql-community-debugsource-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 7855927 Sep 18 22:57 mysql-community-devel-8.4.3-
1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 2382047 Sep 18 22:57 mysql-community-icu-datafiles-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 1552358 Sep 18 22:57 mysql-community-libs-8.4.3-
1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 1512682 Sep 18 22:57 mysql-community-libs-compat-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 2575177 Sep 18 22:57 mysql-community-libs-compatdebuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 2699803 Sep 18 22:57 mysql-community-libsdebuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 52294643 Sep 18 22:58 mysql-community-server-
8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 24998397 Sep 18 22:58 mysql-community-serverdebug-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 161234615 Sep 18 22:58 mysql-community-serverdebug-debuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 200794217 Sep 18 22:58 mysql-community-serverdebuginfo-8.4.3-1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 386301167 Sep 18 22:59 mysql-community-test-8.4.3-
1.el9.x86_64.rpm
-rw-r--r--. 1 7155 31415 24027239 Sep 18 23:00 mysql-community-testdebuginfo-8.4.3-1.el9.x86_64.rpm
现在进行安装。
[root@MySQL ~]# dnf localinstall mysql-community-server-8.4.3-
1.el9.x86_64.rpm
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
Last metadata expiration check: 0:04:32 ago on Mon 30 Dec 2024 12:46:44 PM
CST.
Dependencies resolved.
============================================================================
=====================================================================
Package Architecture
Version Repository Size
============================================================================
=====================================================================
Installing:
mysql-community-server x86_64
8.4.3-1.el9 @commandline 50 M
Installing dependencies:
mysql-community-client x86_64
8.4.3-1.el9 mysql-8.4-lts-community 3.1 M
mysql-community-client-plugins x86_64
8.4.3-1.el9 mysql-8.4-lts-community 1.5 M
mysql-community-common x86_64
8.4.3-1.el9 mysql-8.4-lts-community 575 k
mysql-community-icu-data-files x86_64
8.4.3-1.el9 mysql-8.4-lts-community 2.3 M
mysql-community-libs x86_64
8.4.3-1.el9 mysql-8.4-lts-community 1.5 M
Transaction Summary
============================================================================
=====================================================================
Install 6 Packages
Total size: 59 M
Total download size: 8.9 M
Installed size: 330 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): mysql-community-common-8.4.3-1.el9.x86_64.rpm
1.6 MB/s | 575 kB 00:00
(2/5): mysql-community-client-plugins-8.4.3-1.el9.x86_64.rpm
4.0 MB/s | 1.5 MB 00:00
(3/5): mysql-community-client-8.4.3-1.el9.x86_64.rpm
6.2 MB/s | 3.1 MB 00:00
(4/5): mysql-community-libs-8.4.3-1.el9.x86_64.rpm
11 MB/s | 1.5 MB 00:00
(5/5): mysql-community-icu-data-files-8.4.3-1.el9.x86_64.rpm
9.6 MB/s | 2.3 MB 00:00
----------------------------------------------------------------------------
---------------------------------------------------------------------
Total
15 MB/s | 8.9 MB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing :
1/1
Installing : mysql-community-common-8.4.3-1.el9.x86_64
1/6
Installing : mysql-community-client-plugins-8.4.3-1.el9.x86_64
2/6
Installing : mysql-community-libs-8.4.3-1.el9.x86_64
3/6
Running scriptlet: mysql-community-libs-8.4.3-1.el9.x86_64
3/6
Installing : mysql-community-client-8.4.3-1.el9.x86_64
4/6
Installing : mysql-community-icu-data-files-8.4.3-1.el9.x86_64
5/6
Running scriptlet: mysql-community-server-8.4.3-1.el9.x86_64
6/6
Installing : mysql-community-server-8.4.3-1.el9.x86_64
6/6
Running scriptlet: mysql-community-server-8.4.3-1.el9.x86_64
6/6
Verifying : mysql-community-client-8.4.3-1.el9.x86_64
1/6
Verifying : mysql-community-client-plugins-8.4.3-1.el9.x86_64
2/6
Verifying : mysql-community-common-8.4.3-1.el9.x86_64
3/6
Verifying : mysql-community-icu-data-files-8.4.3-1.el9.x86_64
4/6
Verifying : mysql-community-libs-8.4.3-1.el9.x86_64
5/6
Verifying : mysql-community-server-8.4.3-1.el9.x86_64
6/6
Installed products updated.
Installed:
mysql-community-client-8.4.3-1.el9.x86_64 mysql-community-clientplugins-8.4.3-1.el9.x86_64 mysql-community-common-8.4.3-1.el9.x86_64
mysql-community-icu-data-files-8.4.3-1.el9.x86_64 mysql-community-libs-
8.4.3-1.el9.x86_64 mysql-community-server-8.4.3-1.el9.x86_64
Complete!
至此，安装完成。
3. 容器平台
删除之前的容器安装
[root@MySQL ~]# dnf remove docker \
docker-client \
docker-client-latest \
docker-common \
docker-latest \
docker-latest-logrotate \
docker-logrotate \
docker-engine \
podman \
runc
配置容器软件仓库
[root@MySQL ~]# dnf -y install dnf-plugins-core
dnf config-manager --add-repo https://download.docker.com/linux/rhel/dockerce.repo
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
Last metadata expiration check: 2:23:14 ago on Mon 30 Dec 2024 12:46:44 PM
CST.
Package dnf-plugins-core-4.3.0-16.el9.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
Adding repo from: https://download.docker.com/linux/rhel/docker-ce.repo
[root@MySQL ~]# dnf repolist
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
repo id repo
name
appstream
appstream
baseos
baseos
docker-ce-stable
Docker CE Stable - x86_64
mysql-8.4-lts-community
MySQL 8.4 LTS Community Server
mysql-connectors-community
MySQL Connectors Community
mysql-tools-8.4-lts-community
MySQL Tools 8.4 LTS Community
安装
Docker
相关软件
[root@MySQL ~]# dnf install docker-ce docker-ce-cli containerd.io dockerbuildx-plugin docker-compose-plugin
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use "rhc"
or "subscription-manager" to register.
Last metadata expiration check: 0:19:43 ago on Mon 30 Dec 2024 03:11:17 PM
CST.
Dependencies resolved.
============================================================================
=====================================================================
Package Architecture
Version Repository Size
============================================================================
=====================================================================
Installing:
containerd.io x86_64
1.7.24-3.1.el9 docker-ce-stable 43 M
docker-buildx-plugin x86_64
0.19.3-1.el9 docker-ce-stable 14 M
docker-ce x86_64
3:27.4.1-1.el9 docker-ce-stable 27 M
docker-ce-cli x86_64
1:27.4.1-1.el9 docker-ce-stable 8.0 M
docker-compose-plugin x86_64
2.32.1-1.el9 docker-ce-stable 14 M
Installing dependencies:
container-selinux noarch
3:2.232.1-1.el9 appstream 60 k
fuse-overlayfs x86_64 1.14-
1.el9 appstream 69 k
libslirp x86_64 4.4.0-
8.el9 appstream 70 k
slirp4netns x86_64 1.3.1-
1.el9 appstream 49 k
Installing weak dependencies:
docker-ce-rootless-extras x86_64
27.4.1-1.el9 docker-ce-stable 4.4 M
Transaction Summary
============================================================================
=====================================================================
Install 10 Packages
Total size: 110 M
Installed size: 430 M
Is this ok [y/N]: y
Downloading Packages:
[SKIPPED] containerd.io-1.7.24-3.1.el9.x86_64.rpm: Already downloaded
[SKIPPED] docker-buildx-plugin-0.19.3-1.el9.x86_64.rpm: Already downloaded
[SKIPPED] docker-ce-27.4.1-1.el9.x86_64.rpm: Already downloaded
[SKIPPED] docker-ce-cli-27.4.1-1.el9.x86_64.rpm: Already downloaded
[SKIPPED] docker-ce-rootless-extras-27.4.1-1.el9.x86_64.rpm: Already
downloaded
[SKIPPED] docker-compose-plugin-2.32.1-1.el9.x86_64.rpm: Already downloaded
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing :
1/1
Running scriptlet: container-selinux-3:2.232.1-1.el9.noarch
1/10
Installing : container-selinux-3:2.232.1-1.el9.noarch
1/10
Running scriptlet: container-selinux-3:2.232.1-1.el9.noarch
1/10
Installing : docker-compose-plugin-2.32.1-1.el9.x86_64
2/10
Running scriptlet: docker-compose-plugin-2.32.1-1.el9.x86_64
2/10
Installing : containerd.io-1.7.24-3.1.el9.x86_64
3/10
Running scriptlet: containerd.io-1.7.24-3.1.el9.x86_64
3/10
Installing : libslirp-4.4.0-8.el9.x86_64
4/10
Installing : slirp4netns-1.3.1-1.el9.x86_64
5/10
Installing : fuse-overlayfs-1.14-1.el9.x86_64
6/10
Running scriptlet: fuse-overlayfs-1.14-1.el9.x86_64
6/10
Installing : docker-buildx-plugin-0.19.3-1.el9.x86_64
7/10
Running scriptlet: docker-buildx-plugin-0.19.3-1.el9.x86_64
7/10
Installing : docker-ce-cli-1:27.4.1-1.el9.x86_64
8/10
Running scriptlet: docker-ce-cli-1:27.4.1-1.el9.x86_64
8/10
Installing : docker-ce-rootless-extras-27.4.1-1.el9.x86_64
9/10
Running scriptlet: docker-ce-rootless-extras-27.4.1-1.el9.x86_64
9/10
Installing : docker-ce-3:27.4.1-1.el9.x86_64
10/10
Running scriptlet: docker-ce-3:27.4.1-1.el9.x86_64
10/10
Running scriptlet: container-selinux-3:2.232.1-1.el9.noarch
10/10
Running scriptlet: docker-ce-3:27.4.1-1.el9.x86_64
10/10
Verifying : containerd.io-1.7.24-3.1.el9.x86_64
1/10
Verifying : docker-buildx-plugin-0.19.3-1.el9.x86_64
2/10
Verifying : docker-ce-3:27.4.1-1.el9.x86_64
3/10
Verifying : docker-ce-cli-1:27.4.1-1.el9.x86_64
4/10
Verifying : docker-ce-rootless-extras-27.4.1-1.el9.x86_64
5/10
Verifying : docker-compose-plugin-2.32.1-1.el9.x86_64
6/10
Verifying : container-selinux-3:2.232.1-1.el9.noarch
7/10
Verifying : fuse-overlayfs-1.14-1.el9.x86_64
8/10
Verifying : libslirp-4.4.0-8.el9.x86_64
9/10
Verifying : slirp4netns-1.3.1-1.el9.x86_64
10/10
Installed products updated.
Installed:
container-selinux-3:2.232.1-1.el9.noarch containerd.io-1.7.24-
3.1.el9.x86_64 docker-buildx-plugin-0.19.3-1.el9.x86_64
docker-ce-3:27.4.1-1.el9.x86_64 docker-ce-cli-1:27.4.1-
1.el9.x86_64 docker-ce-rootless-extras-27.4.1-1.el9.x86_64
docker-compose-plugin-2.32.1-1.el9.x86_64 fuse-overlayfs-1.14-
1.el9.x86_64 libslirp-4.4.0-8.el9.x86_64
slirp4netns-1.3.1-1.el9.x86_64
Complete!
启动
Docker
服务
[root@MySQL ~]# systemctl enable --now docker
Created symlink /etc/systemd/system/multi-user.target.wants/docker.service →
/usr/lib/systemd/system/docker.service.
拉取
MySQL
镜像
[root@MySQL ~]# docker search mysql
NAME DESCRIPTION STARS
OFFICIAL
mysql MySQL is a widely used, open-source relation… 15562
[OK]
bitnami/mysql Bitnami container image for MySQL 122
circleci/mysql MySQL is a widely used, open-source relation… 30
cimg/mysql 3
bitnamicharts/mysql Bitnami Helm chart for MySQL 0
ubuntu/mysql MySQL open source fast, stable, multi-thread… 66
rapidfort/mysql RapidFort optimized, hardened image for MySQL 26
elestio/mysql Mysql, verified and packaged by Elestio 1
google/mysql MySQL server for Google Compute Engine 25
docksal/mysql MySQL service images for Docksal - https://d… 0
alpine/mysql mysql client 3
mysql/mysql-server Optimized MySQL Server Docker images. Create… 1024
jumpserver/mysql 1
datajoint/mysql MySQL image pre-configured to work smoothly … 2
ddev/mysql ARM64 base images for ddev-dbserver-mysql-8.… 1
mysql/mysql-router MySQL Router provides transparent routing be… 28
mirantis/mysql 0
ilios/mysql Mysql configured for running Ilios 1
corpusops/mysql https://github.com/corpusops/docker-images/ 0
mysql/mysql-cluster Experimental MySQL Cluster Docker images. Cr… 100
javanile/mysql MySQL for development 0
vulhub/mysql 1
mysql/mysql-operator MySQL Operator for Kubernetes 1
vitess/mysql Lightweight image to run MySQL with Vitess 1
nasqueron/mysql 1
[root@MySQL ~]# docker pull mysql:8.4.3
8.4.3: Pulling from library/mysql
2c0a233485c3: Pull complete
6f5cca38a221: Pull complete
d7c84b66ede0: Pull complete
299f6f88c6cf: Pull complete
d39eae8f9927: Pull complete
ec0557361569: Pull complete
f6d0f80cb1be: Pull complete
d496030b710c: Pull complete
4d755d8c89d1: Pull complete
699d8e3dc44b: Pull complete
Digest:
sha256:106d5197fd8e4892980469ad42eb20f7a336bd81509aae4ee175d852f5cc4565
Status: Downloaded newer image for mysql:8.4.3
docker.io/library/mysql:8.4.3
[root@MySQL ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql 8.4.3 3818a28b4a67 2 months ago 594MB
启动容器
[root@MySQL ~]# docker run --name mysqltest -e MYSQL_ROOT_PASSWORD=123456 -d
mysql:8.4.3
74d9d3e6cd837c7bb1fda3b97083f743e5bba58119ce6b3d68374e9806f23f99
查看并测试
[root@MySQL ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED
STATUS PORTS NAMES
74d9d3e6cd83 mysql:8.4.3 "docker-entrypoint.s…" 26 seconds ago Up 25
seconds 3306/tcp, 33060/tcp mysqltest
[root@MySQL ~]# docker exec -it mysqltest /bin/bash
bash-5.1# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.3 MySQL Community Server - GPL
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> select version();
+-----------+
| version() |
+-----------+
| 8.4.3 |
+-----------+
1 row in set (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> exit
Bye
bash-5.1# exit
exit
删除清理
[root@MySQL ~]# docker stop mysqltest
mysqltest
[root@MySQL ~]# docker rm mysqltest
mysqltest
[root@MySQL ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
如果无法正常使用docker
镜像仓库，可以使用以下指令进行导入导出：
### 导出镜像
[root@MySQL ~]# docker save -o MySQL843.tar mysql:8.4.3
### 导入镜像
[root@MySQL ~]# docker load -i MySQL843.tar
7600fdef234b: Loading layer
[==================================================>] 116.5MB/116.5MB
e17cefd60af0: Loading layer
[==================================================>] 11.26kB/11.26kB
1fa6f54b3274: Loading layer
[==================================================>] 2.359MB/2.359MB
af5010f21ea7: Loading layer
[==================================================>] 17.18MB/17.18MB
abee1c5192d7: Loading layer
[==================================================>] 6.656kB/6.656kB
0576c12e071e: Loading layer
[==================================================>] 3.072kB/3.072kB
66e0995dbcea: Loading layer
[==================================================>] 140.6MB/140.6MB
06bb0f112933: Loading layer
[==================================================>] 3.072kB/3.072kB
793b5c3cdf77: Loading layer
[==================================================>] 335.2MB/335.2MB
099ca8e33f5e: Loading layer
[==================================================>] 17.41kB/17.41kB
Loaded image: mysql:8.4.3
4. 源码部署
前5个步骤与二进制本地一样，但选项如图，点击下载即可
也可以使用该链接，在
Linux
操作系统中直接使用
wget
进行下载：
[root@MySQL ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.4/mysql-
8.4.3.tar.gz
在
Linux
中下载时，如果不指定目录，则在保存在当前目录。
清理之前的环境
[root@MySQL ~]# dnf remove mysql-server -y
[root@MySQL ~]# rm -rf /var/lib/mysql
[root@MySQL ~]# rm -rf /var/log/mysqld.log
[root@MySQL ~]# userdel -r mysql
我们在根目录中创建
mysql
目录，方便操作
[root@MySQL ~]# mkdir /mysql
[root@MySQL ~]# mv mysql-8.4.3.tar.gz /mysql
[root@MySQL ~]# cd /mysql
[root@MySQL mysql]# ll
total 454200
-rw-r--r--. 1 root root 465097732 Sep 17 17:12 mysql-8.4.3.tar.gz
使用命令解压源码包
[root@MySQL mysql-8.4.3]# tar xf mysql-8.4.3.tar.gz
[root@MySQL mysql]# ll
total 454204
drwxr-xr-x. 31 7161 31415 4096 Sep 17 19:09 mysql-8.4.3
-rw-r--r--. 1 root root 465097732 Sep 17 17:12 mysql-8.4.3.tar.gz
[root@MySQL mysql]# cd mysql-8.4.3/
[root@MySQL mysql-8.4.3]# pwd
/mysql/mysql-8.4.3
创建用户，修改目录权限
[root@MySQL mysql-8.4.3]# groupadd mysql
[root@MySQL mysql-8.4.3]# useradd -r -g mysql -s /bin/false mysql
[root@MySQL mysql-8.4.3]# chmod 777 /mysql/ -R
安装需要的软件
[root@MySQL bld]# dnf install cmake openssl-devel ncurses-devel rpcgen gcctoolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-
annobin-annocheck gcc-toolset-12-annobin-plugin-gcc
[root@MySQL bld]# rpm -i
https://yum.oracle.com/repo/OracleLinux/OL9/codeready/builder/x86_64/getPackag
e/libtirpc-devel-1.3.3-9.el9.x86_64.rpm
warning: /var/tmp/rpm-tmp.KJQV1s: Header V3 RSA/SHA256 Signature, key ID
8d8b756f: NOKEY
配置并编译：
[root@MySQL bld]# cmake ..
[root@MySQL bld]# make
[root@MySQL bld]# make install
[root@MySQL bld]# cd /usr/local/mysql
[root@MySQL mysql]# mkdir mysql-files
[root@MySQL mysql]# chown mysql:mysql mysql-files
[root@MySQL mysql]# chmod 750 mysql-files
[root@MySQL mysql]# bin/mysqld --initialize --user=mysql
2024-12-30T14:07:22.396459Z 0 [System] [MY-015017] [Server] MySQL Server
Initialization - start.
2024-12-30T14:07:22.397883Z 0 [System] [MY-013169] [Server]
/usr/local/mysql/bin/mysqld (mysqld 8.4.3) initializing of server in
progress as process 94087
2024-12-30T14:07:22.418620Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2024-12-30T14:07:22.597559Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2024-12-30T14:07:23.220262Z 6 [Note] [MY-010454] [Server] A temporary
password is generated for root@localhost: H2!Yga+&rtiz
2024-12-30T14:07:24.762722Z 0 [System] [MY-015018] [Server] MySQL Server
Initialization - end.
[root@MySQL mysql]# bin/mysqld_safe --user=mysql &
登录测试：
[root@MySQL mysql]# mysql -S /tmp/mysql.sock -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.3
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> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement
before executing this statement.
mysql> alter user 'root'@'localhost' identified by 'redhat';
Query OK, 0 rows affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.01 sec)
mysql>
删除清理
[root@MySQL bld]# make clean
[root@MySQL bld]# rm -rf /usr/local/mysql/
5. Windows平台
前五个步骤与二进制本地一样，但选项如下图，点击【Download】按钮j进入到下载确认页面，单击确认链接直接下载
下载完成，双击执行该可执行程序，打开欢迎页面，单击【
Next
】按钮进入下一步。
进入到用户协议页面，选中复选框，单击【
Next
】按钮，进入下一步。
进入安装类型选择页面，我们这里选择第一个【
Typical
】，选中后直接进行下一页。
进入准备页面，我们单击【
Install
】按钮进行安装。
经过一段时间的安装，安装完成后，显示如下页面，默认选中【
Run MySQL Configurator
】按钮，单击【Finish
】按钮进行配置。
进入配置页面，单击【
Next
】按钮进入下一步
进入选择数据目录页面，这里我们保持默认，单击【
Next
】按钮进入下一步。
进入配置类型和网络配置页面，我们这里保持默认，单击【
Next
】按钮进入下一步。
在账号和角色页面，我们输入
root
账号的密码并确认密码，默认不添加新账号，单击【
Next
】下
一步。
进入服务配置页面，这里我们保持默认，单击【
Next
】按钮进入下一步。
进入服务权限页面，我们这里保持默认，单击【Next】按钮进入下一步。
配置示例数据库是否要载入，选中即为载入，我们这里选择载入，单击【Next】进行下一步。
进入配置摘要页面，单击【Execute】按钮执行配置。
配置执行完毕后，如下所示，单击【Next】进入下一步。
这里显示配置完成的页面，单击【
Finish
】按钮完成配置。
进行命令行测试
图形客户端
也可以使用图形终端工具来进行连接使用，比如：
mysql-workbench-community-8.0.40-winx64
在官方页面下载安装：
默认会话打开时，会提示有报错信息，按如下方法进行更改。
找到
C:\Program Files\MySQL\MySQL Workbench 8.0\workbench
目录下的
os_utils.py
文件，使用notepad++ 软件打开进行编辑。
找到
356
行，将字符集
utf-8
修改为
gbk
即可。（需要保存两次）