Skip to main content

Installation

MySQL Client

到 Oracle 官方 MySQL APT repo 下载配置包（最新版在 2025 之前是 0.8.33 这一支）：

wget https://dev.mysql.com/get/mysql-apt-config_0.8.33-1_all.deb

dpkg -i mysql-apt-config_0.8.33-1_all.deb

安装过程中会弹出一个选择界面：

  • 选 MySQL Server & Cluster (Currently selected: mysql-x.x)
  • 里面会列出可选的版本（客户端一般向下兼容）。
  • 选中 mysql-x.x，确认保存。
更新软件源
apt update
只安装客户端
apt install -y mysql-client
检查客户端
mysql --version

8.0.36

https://downloads.mysql.com/archives/community/

Download Bundle

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.36-1ubuntu22.04_amd64.deb-bundle.tar

Requirements

apt-get update

apt-get install -y libmecab2

Install

基础库
sudo dpkg -i mysql-common_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client-plugins_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient21_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_8.0.36-1ubuntu22.04_amd64.deb
Client
sudo dpkg -i mysql-community-client-core_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-client_8.0.36-1ubuntu22.04_amd64.deb
Server
sudo dpkg -i mysql-community-server-core_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-server_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-server_8.0.36-1ubuntu22.04_amd64.deb

apt-get install -y

Second Instance

mkdir -p /data/mysql2

chown -R mysql:mysql /data/mysql2

mkdir -p /var/log/mysql2

chown -R mysql:mysql /var/log/mysql2

cp /etc/mysql/my.cnf /etc/mysql/my2.cnf

sudo mkdir -p /var/run/mysqld2
sudo chown mysql:mysql /var/run/mysqld2

mysqld --initialize-insecure --user=mysql --datadir=/data/mysql2/data

mysql -hlocalhost -uroot -S /var/run/mysqld2/mysqld.sock

ALTER USER 'root'@'localhost' IDENTIFIED BY 'foo';

RENAME USER 'root'@'localhost' TO 'root'@'%';

No comments to display

Back to top