自动安装mysql数据库连接

# 使用包管理器指定版本安装
sudo apt-get install mysql-server=5.7.35-1ubuntu18.04

# 编辑配置文件
sudo nano /etc/mysql/my.cnf
# 确保以下参数正确
[mysqld]
bind-address = 0.0.0.0
port = 3306

# 登录MySQL
mysql -u root -p
# 授予权限
GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

#!/bin/bash

# 更新包列表
sudo apt-get update

# 安装MySQL服务器
sudo apt-get install -y mysql-server

# 配置MySQL
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo sed -i 's/bind-address.*/bind-address = 0.0.0.0/' /etc/mysql/my.cnf

# 重启MySQL服务
sudo systemctl restart mysql

# 设置root用户密码
mysql -u root <<EOF
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF

echo "MySQL installed and configured successfully!"