Debian11 安装 MySQL8

官方部署文档：

https://dev.mysql.com/doc/refman/8.0/en/installing.html

https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html

安装：

#系统版本
root@debian:~# lsb_release -a
No LSB modules are available.
Distributor ID:	Debian
Description:	Debian GNU/Linux 11 (bullseye)
Release:	11
Codename:	bullseye

root@debian:~# wget https://dev.mysql.com/get/mysql-apt-config_0.8.18-1_all.deb

root@debian:~# dpkg -i mysql-apt-config_0.8.18-1_all.deb

#更新仓库源
root@debian:~# apt update 

#更新过程中，报错如下:

#下面的 467B942D3A79BD29 是 NO_PUBKEY 的值
root@debian:~# apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
Executing: /tmp/apt-key-gpghome.Aww7nGrUEJ/gpg.1.sh --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
gpg: key 467B942D3A79BD29: public key "MySQL Release Engineering <mysql-build@oss.oracle.com>" imported
gpg: Total number processed: 1
gpg:               imported: 1

#安装 MySQL8
root@debian:~# apt update
root@debian:~# apt install mysql-server -y

#显示所有仓库
root@debian:~# apt policy mysql-server

#查看数据库状态
root@debian:~# systemctl status mysql
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: active (running) since Thu 2022-06-02 10:27:17 CST; 1min 52s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
   Main PID: 4730 (mysqld)
     Status: "Server is operational"
      Tasks: 37 (limit: 4634)
     Memory: 367.4M
        CPU: 1.066s
     CGroup: /system.slice/mysql.service
             └─4730 /usr/sbin/mysqld

Jun 02 10:27:17 debian systemd[1]: Starting MySQL Community Server...
Jun 02 10:27:17 debian systemd[1]: Started MySQL Community Server.

root@debian:~# systemctl enable mysql

#数据库初始化
root@debian:~# mysql_secure_installation

root@debian:~# mysql -uroot -p1

mysql> status

#卸载数据库
apt autoremove mysql-server
sudo apt-get -f install
sudo apt-get remove --purge mysql-\*
sudo apt-get install mysql-server mysql-client

#安装目录位置
root@debian:~# find / -name mysql
/etc/mysql
/var/log/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/bash-completion/completions/mysql
/usr/lib/mysql
/usr/bin/mysql

# 查看 mysql 配置文件加载顺序
/usr/bin/mysql --verbose --help | grep -A 1 'Default options'
# 输出[首先读取 /etc/my.cnf 文件，不存在则继续读 /etc/mysql/my.cnf 文件，还不存在便会去读~/.my.cnf文件]
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

create user root@'10.0.0.%' identified by '123';

grant all on *.* to root@'10.0.0.%';