sudo apt update && sudo apt upgrade -y

sudo rm -rf /var/lib/mysql /etc/mysql
sudo apt autoremove mysql* --purge

wget https://dev.mysql.com/get/mysql-apt-config_0.8.17-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.17-1_all.deb

在配置界面选择：

• MySQL Server & Cluster → 选择 mysql-8.0

• Tools & Connectors → 保持默认启用

• 选择Ubuntu Focal

  （兼容性最佳）

  sudo apt update
  sudo apt install mysql-server -y

sudo apt update
sudo apt install mysql-server -y

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密码';
FLUSH PRIVILEGES;
EXIT;

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

sudo ufw allow 3306/tcp
sudo ufw reload

mysql -V

sudo systemctl status mysql

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
FLUSH PRIVILEGES;

sudo systemctl restart mysql

-- 登录MySQL（需本地root密码）
mysql -u root -p

-- 创建远程root用户（MySQL 8+需分步操作）
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_strong_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

SELECT User, Host FROM mysql.user WHERE User = 'root';