Debian 安装 MySQL
标签:
日期: 2024-02-15 | 作者: 七七 | 浏览: 65
1. 下载源仓库
# 官网下载最新源仓库包
wget https://dev.mysql.com/get/mysql-apt-config_0.8.34-1_all.deb
2. 安装源仓库
# 安装源仓库
sudo dpkg -i mysql-apt-config_0.8.34-1_all.deb
3. 更新升级源
# 更新升级
sudo apt update
sudo apt upgrade
4. 安装MySQL
# 安装MySQL
sudu apt install mysql-server
# 期间会提示输入密码, 并确认密码
5. 完善相关配置
# 配置文件
vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
# 允许远程访问
bind-address = 0.0.0.0
# 修改端口号
port = 8806
# 内存优化
performance_schema = off
6. 允许用户远程访问
# 进入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;