跳到主要内容

下载对应系统版本的mysql-apt-config包

# debian12 查询系统版本
~ hostnamectl | grep Operating | cut -d: -f 2 | awk '{print $1 $2,$3}'# 下载mysql-apt-config包
~ wget https://repo.mysql.com/apt/debian/pool/mysql-apt-config/m/mysql-apt-config/mysql-apt-config_0.8.29-1_all.deb

安装mysql-apt-config包

# 安装下载的deb包
~ sudo dpkg -i mysql-apt-config_0.8.29-1_all.deb
# 更新apt
~ sudo apt update

注意:安装mysql-apt-config使用上下键选择菜单中的ok

debian12-install-mysql-client

安装mysql客户端

查询apt中的mysql版本

# 更新apt
~ sudo apt update
# 查询apt中的mysql版本号
~ sudo apt list | grep ^mysql

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

mysql-apt-config/unknown,now 0.8.29-1 all [installed]
mysql-client/unknown,now 8.0.42-1debian12 amd64 [installed]
mysql-common/unknown,now 8.0.42-1debian12 amd64 [installed]
mysql-community-client-core-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-client-core/unknown,now 8.0.42-1debian12 amd64 [installed]
mysql-community-client-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-client-plugins-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-client-plugins/unknown,now 8.0.42-1debian12 amd64 [installed,automatic]
mysql-community-client/unknown,now 8.0.42-1debian12 amd64 [installed,automatic]
mysql-community-server-core-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-server-core/unknown 8.0.42-1debian12 amd64
mysql-community-server-debug-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-server-debug/unknown 8.0.42-1debian12 amd64
mysql-community-server/unknown 8.0.42-1debian12 amd64
mysql-community-test-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-community-test-debug/unknown 8.0.42-1debian12 amd64
mysql-community-test/unknown 8.0.42-1debian12 amd64
mysql-connector-j/unknown 9.3.0-1debian12 all
mysql-connector-odbc-dbgsym/unknown 9.3.0-1debian12 amd64
mysql-connector-odbc-setup-dbgsym/unknown 9.3.0-1debian12 amd64
mysql-connector-odbc-setup/unknown 9.3.0-1debian12 amd64
mysql-connector-odbc/unknown 9.3.0-1debian12 amd64
mysql-connector-python-py3-dbgsym/unknown 8.4.0-1debian12 amd64
mysql-connector-python-py3/unknown 8.4.0-1debian12 amd64
mysql-router-community-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-router-community/unknown 8.0.42-1debian12 amd64
mysql-router/unknown 8.0.42-1debian12 amd64
mysql-sandbox/stable 3.2.05-1 all
mysql-server/unknown 8.0.42-1debian12 amd64
mysql-shell-dbgsym/unknown 8.0.42-1debian12 amd64
mysql-shell/unknown 8.0.42-1debian12 amd64
mysql-testsuite/unknown 8.0.42-1debian12 amd64
mysqltcl/stable 3.052-4 amd64
mysqltuner/stable 1.9.9-1 all
mysqlx-connector-python-py3-dbgsym/unknown 8.4.0-1debian12 amd64
mysqlx-connector-python-py3/unknown 8.4.0-1debian12 amd64

安装mysql客户端

~ apt-get -y install mysql-client

这时会遇到报错

mysql-community-client-core : Depends: libssl1.1 (>= 1.1.1) but it is not installable

根据报错信息,这是由于 Debian 12(Bookworm)默认不再提供 libssl1.1,而是升级到 OpenSSL 3.0 导致的依赖冲突。以下是具体解决方案

临时添加 Debian 11 软件源

# 编辑 sources.list
~ sudo vim /etc/apt/sources.list
# 添加以下行
deb http://deb.debian.org/debian bullseye main

# 更新并指定安装 libssl1.1sudo apt update
~ sudo apt install libssl1.1 -t bullseye

安装成功后删除刚刚添加的行,再重新安装mysql-client

~ apt-get -y install mysql-client
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
mysql-common mysql-community-client mysql-community-client-core mysql-community-client-plugins
The following NEW packages will be installed:
mysql-client mysql-community-client mysql-community-client-plugins
The following packages will be upgraded:
mysql-common mysql-community-client-core
2 upgraded, 3 newly installed, 0 to remove and 62 not upgraded.
Need to get 6,437 kB of archives.
After this operation, 71.8 MB of additional disk space will be used.
Get:1 http://repo.mysql.com/apt/debian bookworm/mysql-8.0 amd64 mysql-common amd64 8.0.42-1debian12 [60.1 kB]
Get:2 http://repo.mysql.com/apt/debian bookworm/mysql-8.0 amd64 mysql-community-client-core amd64 8.0.42-1debian12 [1,871 kB]
Get:3 http://repo.mysql.com/apt/debian bookworm/mysql-8.0 amd64 mysql-community-client-plugins amd64 8.0.42-1debian12 [1,287 kB]
Get:4 http://repo.mysql.com/apt/debian bookworm/mysql-8.0 amd64 mysql-community-client amd64 8.0.42-1debian12 [3,161 kB]
Get:5 http://repo.mysql.com/apt/debian bookworm/mysql-8.0 amd64 mysql-client amd64 8.0.42-1debian12 [58.8 kB]
Fetched 6,437 kB in 1s (5,530 kB/s)
apt-listchanges: Reading changelogs...
(Reading database ... 45333 files and directories currently installed.)
Preparing to unpack .../mysql-common_8.0.42-1debian12_amd64.deb ...
Unpacking mysql-common (8.0.42-1debian12) over (8.0.20-1debian10) ...
Preparing to unpack .../mysql-community-client-core_8.0.42-1debian12_amd64.deb ...
Unpacking mysql-community-client-core (8.0.42-1debian12) over (8.0.20-1debian10) ...
Selecting previously unselected package mysql-community-client-plugins.
Preparing to unpack .../mysql-community-client-plugins_8.0.42-1debian12_amd64.deb ...
Unpacking mysql-community-client-plugins (8.0.42-1debian12) ...
Selecting previously unselected package mysql-community-client.
Preparing to unpack .../mysql-community-client_8.0.42-1debian12_amd64.deb ...
Unpacking mysql-community-client (8.0.42-1debian12) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../mysql-client_8.0.42-1debian12_amd64.deb ...
Unpacking mysql-client (8.0.42-1debian12) ...
Setting up mysql-common (8.0.42-1debian12) ...
Installing new version of config file /etc/mysql/conf.d/mysql.cnf ...
Installing new version of config file /etc/mysql/my.cnf.fallback ...
Setting up mysql-community-client-plugins (8.0.42-1debian12) ...
Setting up mysql-community-client-core (8.0.42-1debian12) ...
Setting up mysql-community-client (8.0.42-1debian12) ...
Setting up mysql-client (8.0.42-1debian12) ...
Processing triggers for man-db (2.11.2-2) ...
Processing triggers for libc-bin (2.36-9+deb12u10) ...

安装完成