# 步骤1：登录Azure门户
https://portal.azure.com

# 步骤2：创建Azure Database for MySQL服务器
1. 在Azure门户中，点击”创建资源” → 搜索”Azure Database for MySQL”
2. 选择”Azure Database for MySQL – 灵活服务器”或”Azure Database for MySQL – 单一服务器”
3. 点击”创建”

# 步骤3：配置基本设置
– 订阅：选择您的Azure订阅
– 资源组：创建或选择现有资源组
– 服务器名称：输入唯一的服务器名称
– 区域：选择合适的Azure区域
– 版本：选择MySQL版本（8.0或5.7）
– 计算 + 存储：选择合适的计算和存储配置

# 步骤4：配置管理员账户
– 管理员用户名：输入管理员用户名
– 密码：输入强密码

# 步骤5：配置网络设置
– 连接方法：选择”公共访问”或”私有访问”
– 防火墙规则：添加允许访问的IP地址

# 步骤6：完成创建
点击”查看 + 创建” → 确认配置 → 点击”创建”

# 步骤7：连接到Azure Database for MySQL
# 使用MySQL客户端连接
mysql -h server-name.mysql.database.azure.com -u admin-username -p

# 输出示例
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12345
Server version: 8.0.21 Azure Database for MySQL – Flexible Server

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

# 步骤1：创建Azure虚拟机
1. 在Azure门户中，点击”创建资源” → 选择”虚拟机”
2. 配置虚拟机基本设置：
– 订阅：选择您的Azure订阅
– 资源组：创建或选择现有资源组
– 虚拟机名称：输入虚拟机名称
– 区域：选择合适的Azure区域
– 映像：选择Linux发行版（如Ubuntu Server 20.04 LTS）
– 大小：选择合适的虚拟机大小
– 认证类型：选择”密码”或”SSH公钥”
– 用户名：输入用户名
– 密码/SSH公钥：输入密码或SSH公钥

# 步骤2：配置网络设置
– 虚拟网络：创建或选择现有虚拟网络
– 子网：选择合适的子网
– 公共IP：创建或选择现有公共IP
– 网络安全组：创建或选择现有网络安全组，确保端口3306开放

# 步骤3：完成创建
点击”查看 + 创建” → 确认配置 → 点击”创建”

# 步骤4：连接到虚拟机
# 使用SSH连接到虚拟机
ssh username@public-ip-address

# 步骤5：在虚拟机上安装MySQL
# 更新系统
# sudo apt update
# sudo apt upgrade -y

# 安装MySQL
# sudo apt install mysql-server -y

# 启动MySQL服务
# sudo systemctl start mysql
# sudo systemctl enable mysql

# 安全配置
# sudo mysql_secure_installation

# 配置远程访问
# sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# 将bind-address = 127.0.0.1修改为bind-address = 0.0.0.0

# 重启MySQL服务
# sudo systemctl restart mysql

# 创建远程访问用户
# sudo mysql -u root -p
mysql> CREATE USER ‘fgedu’@’%’ IDENTIFIED BY ‘Password123!’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘fgedu’@’%’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> EXIT;

# 验证MySQL服务状态
# sudo systemctl status mysql
● mysql.service – MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2026-04-01 10:00:00 UTC; 1min ago
Process: 12345 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 12346 (mysqld)
Tasks: 38 (limit: 4915)
CGroup: /system.slice/mysql.service
└─12346 /usr/sbin/mysqld

Apr 01 10:00:00 vm-name systemd[1]: Starting MySQL Community Server…
Apr 01 10:00:00 vm-name systemd[1]: Started MySQL Community Server.

# 配置MySQL参数
# sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
# 基础配置
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
pid-file=/var/run/mysqld/mysqld.pid

# 内存配置
innodb_buffer_pool_size=2G
key_buffer_size=256M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=4M
join_buffer_size=4M

# 连接配置
max_connections=500
max_connect_errors=10000
wait_timeout=3600
interactive_timeout=3600

# 日志配置
slow_query_log=1
slow_query_log_file=/var/log/mysql/slow.log
long_query_time=1
log_bin=/var/log/mysql/binlog/mysql-bin
expire_logs_days=7

# 存储引擎配置
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_log_file_size=512M
innodb_log_buffer_size=32M

# 重启MySQL服务
# sudo systemctl restart mysql

# 验证配置
# mysql -u root -p -e “SHOW VARIABLES LIKE ‘innodb_buffer_pool_size’;”
+————————-+————+
| Variable_name | Value |
+————————-+————+
| innodb_buffer_pool_size | 2147483648 |
+————————-+————+

# 验证远程连接
# mysql -h public-ip-address -u fgedu -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12345
Server version: 8.0.25-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

# 案例：部署Azure Database for MySQL灵活服务器

# 步骤1：登录Azure CLI
# az login

# 步骤2：创建资源组
# az group create –name fgedu-rg –location eastasia

# 步骤3：创建Azure Database for MySQL灵活服务器
# az mysql flexible-server create \
–name fgedu-mysql-server \
–resource-group fgedu-rg \
–location eastasia \
–admin-user fgeduadmin \
–admin-password Password123! \
–sku-name Standard_B2ms \
–storage-size 10240 \
–version 8.0

# 步骤4：配置防火墙规则
# az mysql flexible-server firewall-rule create \
–name allow-all \
–server-name fgedu-mysql-server \
–resource-group fgedu-rg \
–start-ip-address 0.0.0.0 \
–end-ip-address 255.255.255.255

# 步骤5：连接到服务器
# mysql -h fgedu-mysql-server.mysql.database.azure.com -u fgeduadmin -p

# 步骤6：创建数据库和用户
mysql> CREATE DATABASE fgedudb;
mysql> CREATE USER ‘fgedu’@’%’ IDENTIFIED BY ‘Password123!’;
mysql> GRANT ALL PRIVILEGES ON fgedudb.* TO ‘fgedu’@’%’;
mysql> FLUSH PRIVILEGES;

# 步骤7：验证数据库
mysql> USE fgedudb;
mysql> CREATE TABLE fgedu_users (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), email VARCHAR(100));
mysql> INSERT INTO fgedu_users (name, email) VALUES (‘张三’, ‘zhangsan@fgedu.net.cn’);
mysql> SELECT * FROM fgedu_users;
+—-+——–+————————+
| id | name | email |
+—-+——–+————————+
| 1 | 张三 | zhangsan@fgedu.net.cn |
+—-+——–+————————+

# 案例：在Ubuntu虚拟机上部署MySQL

# 步骤1：创建Azure虚拟机
# az vm create \
–resource-group fgedu-rg \
–name fgedu-mysql-vm \
–image Ubuntu2004 \
–size Standard_B2ms \
–admin-username fgedu \
–admin-password Password123! \
–public-ip-address fgedu-mysql-ip \
–public-ip-sku Standard \
–nsg fgedu-mysql-nsg \
–nsg-rule SSH \
–nsg-rule MySQL –nsg-rule-type inbound –nsg-rule-priority 1001 –nsg-rule-access allow –nsg-rule-direction inbound –nsg-rule-source-address-prefixes ‘*’ –nsg-rule-source-port-ranges ‘*’ –nsg-rule-destination-address-prefixes ‘*’ –nsg-rule-destination-port-ranges 3306

# 步骤2：连接到虚拟机
# ssh fgedu@public-ip-address

# 步骤3：安装MySQL
# sudo apt update
# sudo apt install mysql-server -y

# 步骤4：安全配置
# sudo mysql_secure_installation

# 步骤5：配置远程访问
# sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# 将bind-address = 127.0.0.1修改为bind-address = 0.0.0.0

# 步骤6：重启MySQL服务
# sudo systemctl restart mysql

# 步骤7：创建远程访问用户
# sudo mysql -u root -p
mysql> CREATE USER ‘fgedu’@’%’ IDENTIFIED BY ‘Password123!’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘fgedu’@’%’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> EXIT;

# 步骤8：验证MySQL服务
# sudo systemctl status mysql

# 步骤9：验证远程连接
# mysql -h public-ip-address -u fgedu -p

# 步骤10：创建数据库和表
mysql> CREATE DATABASE fgedudb;
mysql> USE fgedudb;
mysql> CREATE TABLE fgedu_users (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), email VARCHAR(100));
mysql> INSERT INTO fgedu_users (name, email) VALUES (‘李四’, ‘lisi@fgedu.net.cn’);
mysql> SELECT * FROM fgedu_users;
+—-+——–+———————-+
| id | name | email |
+—-+——–+———————-+
| 1 | 李四 | lisi@fgedu.net.cn |
+—-+——–+———————-+