#!/bin/bash
# Set your password
ROOT_PASSWORD=0
# Update package lists
sudo apt-get update
# Preconfiguration setup
sudo debconf-set-selections <<< "mysql-server mysql-server/root_password password $ROOT_PASSWORD"
sudo debconf-set-selections <<< "mysql-server mysql-server/root_password_again password $ROOT_PASSWORD"
# Install MySQL Server
sudo DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server
# Install MySQL Client
sudo apt-get install -y mysql-client
# Install MySQL development libraries
sudo apt-get install -y libmysqlclient-dev
# Change MySQL configuration to allow remote access
sudo sed -i 's/bind-address = 127.0.0.1/#bind-address = 127.0.0.1/g' /etc/mysql/mysql.conf.d/mysqld.cnf
# Restart MySQL service
sudo service mysql restart
# Login to MySQL and setup root user for remote access
mysql -uroot -p$ROOT_PASSWORD -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '$ROOT_PASSWORD' WITH GRANT OPTION; FLUSH PRIVILEGES;"
mysql脚本自动安装方法
最新推荐文章于 2023-12-14 20:45:15 发布