安装MySQL的五种方法(Linux系统和Windows系统)

一.在Linux系统中安装MySQL

第一种方法:在线YUM仓库

首先打开MySQL官网首页 www.mysql.com

找到【DOWNLOADS】选项,点击

下拉,找到 【MySQL Community(GPL) Downloads】

  在社区版下载页面中,【 MySQL Yum Repository 】链接为在线仓库安装,【 MySQL Community
Server 】链接为二进制安装和源码安装,【 MySQL Installer for Windows 】为之前老版本在 Windows 平台安装使用,新版本已经不可以用。

 

点击【 MySQL Yum Repository 】链接之后,进入在线仓库安装页面,单击【 Download 】按钮进入仓库 下载确认页面。

 

点击确认链接后,浏览器会自动下载仓库安装包,可以将安装包下载好传送到 Linux 操作系统中
也可以 将该安装包的下载链接在Linux 操作系统中按照以下命令直接进行下载。
wget https://repo.mysql.com//mysql84-community-release-el9-1.noarch.rpm

可以使用rpm直接安装

 

rpm -i https://repo.mysql.com//mysql84-community-release-el9-1.noarch.rpm

dnf repolist

dnf install mysql-server

 

[root@MySQL ~]# rpm -i https://repo.mysql.com//mysql84-community-releaseel9-1.noarch.rpm
warning: /var/tmp/rpm-tmp.QsZluK: Header V4 RSA/SHA256 Signature, key ID
a8d3785c: NOKEY
[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
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

[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 <mysql-build@oss.oracle.com>"
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!

 删除清理

[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
userdel: mysql mail spool (/var/spool/mail/mysql) not found
userdel: mysql home directory (/var/lib/mysql) not found

第二种方法 :二进制本地

 在上面的页面中点击【MySQL Community Server】链接进入下载页面,在列表选项中选择对应的选 项,我们这里选择如下选项。

 单击第一项【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

我们使用wget命令直接下载。下载完成后,我们使用以下命令进行解压。

[root@MySQL ~]# tar xf mysql-8.4.3-1.el9.x86_64.rpm-bundle.tar

开始安装

dnf localinstall mysql-community-server-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!

至此安装完成。

删除清理 

[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
userdel: mysql mail spool (/var/spool/mail/mysql) not found
userdel: mysql home directory (/var/lib/mysql) not found

第三种方法:容器平台 

删除之前的容器安装

[root@MySQL ~]# dnf remove docker \
docker-client \
docker-client-latest \
docker-common \
docker-latest \
docker-latest-logrotate \
docker-logrotate \
docker-engine \
podman \
runc

配置容易软件仓库

dnf -y install dnf-plugins-core

dnf repolist

 

[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相关软件

dnf install docker-ce docker-ce-cli containerd.io docker-buildx-plugin 
docker-compose-plugin
[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服务

systemctl enable --now docker

 

拉取MySQL镜像

docker search mysql

docker pull mysql:8.4.3

docker images
[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

启动容器

docker run --name mysqltest -e MYSQL_ROOT_PASSWORD=123456 -d
mysql:8.4.3

 

查看并测试

docker ps

 

删除清理 

[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

第四种方法:源码部署 

在下载页面点击【 MySQL Community(GPL) Downloads 】链接进入社区版下载页面,我们选择合适的 版本和选项。

 

 点击【Download】按钮进入到下载确认页面,点击连接继续下载

 也可以使用该连接,在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 bld]# dnf install cmake openssl-devel ncurses-devel rpcgen gcc-toolset-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

 

登录测试 

清理删除 

[root@MySQL bld]# make clean
[root@MySQL bld]# rm -rf /usr/local/mysql/

二. Windows平台

第五种方法:服务端安装

在下载页面点击【 MySQL Community(GPL) Downloads 】链接进入社区版下载页面,我们选择合适的版本和选项。

 

 点击【Download】按钮j进入到下载确认页面,单击确认链接直接下载。

下载完成,双击执行该可执行程序,打开欢迎页面,单击【 Next 】按钮进入下一步。

 

进入到用户协议页面,选中复选框,单击【 Next 】按钮,进入下一步

 

进入安装类型选择页面,我们这里选择第一个【 Typical 】,选中后直接进行下一页。
进入准备页面,我们单击【 Install 】按钮进行安装。
经过一段时间的安装,安装完成后,显示如下页面,默认选中【 Run MySQL Configurator 】按钮,单击 【Finish 】按钮进行配置。
进入配置页面,单击【 Next 】按钮进入下一步。
进入选择数据目录页面,这里我们保持默认,单击【 Next 】按钮进入下一步。
进入配置类型和网络配置页面,我们这里保持默认,单击【 Next 】按钮进入下一步。
在账号和角色页面,我们输入 root 账号的密码并确认密码,默认不添加新账号,单击【 Next 】下一步。
进入服务配置页面,这里我们保持默认,单击【 Next 】按钮进入下一步。
进入服务权限页面,我们这里保持默认,单击【 Next 】按钮进入下一步。
配置示例数据库是否要载入,选中即为载入,我们这里选择载入,单击【 Next 】进行下一步。
进入配置摘要页面,单击【 Execute 】按钮执行配置。
这里显示配置完成的页面,单击【 Finish 】按钮完成配置。

命令行测试

连接测试:我们将命令行工具固定到任务栏,也可以创建快捷方式到桌面,使用起来很方便。
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.4.3 |
+-----------+
1 row in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.02 sec)
mysql>

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:/a/951540.html

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈qq邮箱809451989@qq.com,一经查实,立即删除!

相关文章

基于mybatis-plus历史背景下的多租户平台改造

前言 别误会&#xff0c;本篇【并不是】 要用mybatis-plus自身的多租户方案&#xff1a;在表中加一个tenant_id字段来区分不同的租户数据。并不是的&#xff01; 而是在假设业务系统已经使用mybatis-plus多数据源的前提下&#xff0c;如何实现业务数据库隔开的多租户系统。 这…

RabbitMQ高级篇之MQ可靠性 数据持久化

文章目录 消息丢失的原因分析内存存储的缺陷如何确保 RabbitMQ 的消息可靠性&#xff1f;数据持久化的三个方面持久化对性能的影响持久化实验验证性能对比Spring AMQP 默认持久化总结 消息丢失的原因分析 RabbitMQ 默认使用内存存储消息&#xff0c;但这种方式带来了两个主要问…

Openssl1.1.1s rpm包构建与升级

rpmbuild入门知识 openssh/ssl二进制升级 文章目录 前言一、资源准备1.下载openssh、openssl二进制包2.安装rpmbuild工具3.拷贝源码包到SOURCES目录下4.系统开启telnet&#xff0c;防止意外导致shh无法连接5.编译工具安装6.补充说明 二、制作 OpenSSL RPM 包1.编写 SPEC 文件2.…

【Unity3D】apk加密(global-metadata.dat加密)

涉及&#xff1a;apk、aab、global-metadata.dat、jks密钥文件、APKTool、zipalign 使用7z打开apk文件观察发现有如下3个针对加密的文件。 xxx.apk\assets\bin\Data\Managed\Metadata\global-metadata.dat xxx.apk\lib\armeabi-v7a\libil2cpp.so xxx.apk\lib\arm64-v8a\libil…

[免费]微信小程序(高校就业)招聘系统(Springboot后端+Vue管理端)【论文+源码+SQL脚本】

大家好&#xff0c;我是java1234_小锋老师&#xff0c;看到一个不错的微信小程序(高校就业)招聘系统(Springboot后端Vue管理端)&#xff0c;分享下哈。 项目视频演示 【免费】微信小程序(高校就业)招聘系统(Springboot后端Vue管理端) Java毕业设计_哔哩哔哩_bilibili 项目介绍…

RNN心脏病预测-Pytorch版本

本文为为&#x1f517;365天深度学习训练营内部文章 原作者&#xff1a;K同学啊 一 导入数据 import numpy as np import pandas as pd import torch from torch import nn import torch.nn.functional as F import seaborn as sns from sklearn.preprocessing import Standard…

科普CMOS传感器的工作原理及特点

在当今数字化成像的时代&#xff0c;图像传感器无疑是幕后的关键 “功臣”&#xff0c;它宛如一位神奇的 “光影魔法师”&#xff0c;通过光电效应这一奇妙的物理现象&#xff0c;将光子巧妙地转换成电荷&#xff0c;为图像的诞生奠定基础。而在众多类型的图像传感器中&#xf…

Ubuntu 18.04 解决screen无法滚屏的问题

Ubuntu 18.04 解决screen无法滚屏的问题_ubuntu screen 无法上滑-CSDN博客文章浏览阅读2.7k次&#xff0c;点赞2次&#xff0c;收藏3次。在etc/screenrc中加入termcapinfo xterm* ti:te重新进入screen的sessionscreen -d -r XXX_ubuntu screen 无法上滑https://blog.csdn.net/w…

2025年01月09日Github流行趋势

1. 项目名称&#xff1a;khoj 项目地址url&#xff1a;https://github.com/khoj-ai/khoj项目语言&#xff1a;Python历史star数&#xff1a;22750今日star数&#xff1a;1272项目维护者&#xff1a;debanjum, sabaimran, MythicalCow, aam-at, eltociear项目简介&#xff1a;你…

Spring boot接入xxl-job

Spring boot接入xxl-job 导入maven包加入配置增加配置类创建执行器类&#xff08;写job的业务逻辑&#xff09;去控制台中配置job 导入maven包 <dependency><groupId>com.xuxueli</groupId><artifactId>xxl-job-core</artifactId><version>…

Cglib动态代理中method.invoke与methodProxy.invokeSuper区别浅尝

前段时间看了黑马Spring教程中&#xff0c;有期视频讲解Cglib动态代理。 代码如下图&#xff1a; 可以看到调用目标对象的方法代码为&#xff1a; method.invoke(target,objects);在其他地方看到的此处代码是&#xff1a; methodProxy.invokeSuper(o,objects);注意&#xff…

【Linux 之一 】Linux常用命令汇总

Linux常用命令 ./catcd 命令chmodclearcphistoryhtoplnmkdirmvpwdrmtailunamewcwhoami 我从2021年4月份开始才开始真正意义上接触Linux&#xff0c;最初学习时是一脸蒙圈&#xff0c;啥也不会&#xff0c;啥也不懂&#xff0c;做了很多乱七八糟&#xff0c;没有条理的笔记。不知…

NO.3 《机器学习期末复习篇》以题(问答题)促习(人学习),满满干huo,大胆学大胆补!

目录 &#x1f50d; 1. 对于非齐次线性模型 &#xff0c;试将其表示为齐次线性模型形式。 ​编辑 &#x1f50d; 2. 某汽车公司一年内各月份的广告投入与月销量数据如表3-28所示&#xff0c;试根据表中数据构造线性回归模型&#xff0c;并使用该模型预测月广告投入为20万元时…

Javascript算法——贪心算法(一)

贪心算法详解&#xff08;JavaScript&#xff09;&#xff08;局部最优->全局最优&#xff09; 贪心算法&#xff08;Greedy Algorithm&#xff09;是一种在每一步选择中都采取当前状态下的最优选择&#xff08;局部最优&#xff09;的算法设计方法。通过局部最优解的累积&…

【Vue】分享一个快速入门的前端框架以及如何搭建

先上效果图: 登录 菜单: 下载地址: 链接&#xff1a;https://pan.baidu.com/s/1m-ZlBARWU6_2n8jZil_RAQ 提取码&#xff1a;ui20 … 主要是可以自定义设置token,更改后端请求地址较为方便。 应用设置: 登录与token设置: 在这里设置不用登录,可以请求的接口: request.js i…

jdk8升级JDK21(Springboot2.7.18升级Springboot3.4.0)

目录 背景&#xff1a; 一、maven升级 二、代码改造 2.1 javax替换为jakarta 2.2 swagger2升级swagger3相关更新 2.2.1 新增SpringDocConfig配置类 2.2.2 全局代码更新 2.2.3 全局代码替换&#xff08;普通正则替换&#xff09; 2.3 Mybatis Plus升级 2.4 logback.xm…

数据库(3)--针对列的CRUD操作

1.Create 新增 语法&#xff1a; insert into 表名 &#xff08;列名&#xff09;values &#xff08;列&#xff09;... 创建一个学生表用于演示&#xff1a; create table if not exists student( id bigint comment 编号, name varchar(20) comment 姓名 ); 1.1直接增加…

加速科技荣获“浙江省企业研究院”认定

近日&#xff0c;浙江省经济和信息化厅公布“2024年认定&#xff08;备案&#xff09;省级企业研发机构名单”。经过多轮严格评审和公示&#xff0c;加速科技荣获“省企业研究院”认定。这是加速科技继获国家级专精特新“小巨人”企业认定荣誉后的又一里程碑。 “浙江省企业研究…

leetcode:1784. 检查二进制字符串字段(python3解法)

难度&#xff1a;简单 给你一个二进制字符串 s &#xff0c;该字符串 不含前导零 。 如果 s 包含 零个或一个由连续的 1 组成的字段 &#xff0c;返回 true​​​ 。否则&#xff0c;返回 false 。 示例 1&#xff1a; 输入&#xff1a;s "1001" 输出&#xff1a;fa…

双向列表的实现(C++)

一.实现思路 主要是一个空间存储一个数值&#xff0c;然后为了索引后面的数据单元和前面的数据单元&#xff0c;所以在每个空间里面还要存储前面和后面数据单元的指针&#xff0c;就形成了每个数据单元 后面就是要管理的是双向列表的头结点和尾节点&#xff0c;方便实现后面的头…