Debian安装MySQL

1. 更新下载MySQL资源仓库

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

2. 安装更新

sudo dpkg -i mysql-apt-config_0.8.36-1_all.deb

3. 更新升级

sudo apt update
sudo apt upgrade

4. 安装MySQL

sudu apt install mysql-server
# 期间会提示输入密码, 并确认密码

5. 修改完善MySQL相关配置

# 配置文件
vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
# 允许远程访问
bind-address = 0.0.0.0

# 修改端口号
port = 13306

# 内存优化，按需
performance_schema = off

# 进入MySQL后，执行相关语句允许远程访问（MySQL 5.7.40版本后）
> CREATE USER 'root'@'%' IDENTIFIED BY '密码';
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
> FLUSH PRIVILEGES;

# 进入MySQL后，执行相关语句允许远程访问(5.7.38版本之前)
> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
> FLUSH PRIVILEGES;

# 查看端口
netstat -tulnp | grep mysql