2025 ubuntu24系统宿主机上在线安装mysql数据库完整演示

说明：这是ubuntu24系统和安装后mysql的版本

root@master:/home/ubuntu# cat /etc/os-release
PRETTY_NAME="Ubuntu 24.04.2 LTS"
NAME="Ubuntu"
VERSION_ID="24.04"
VERSION="24.04.2 LTS (Noble Numbat)"
VERSION_CODENAME=noble
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=noble
LOGO=ubuntu-logo
root@master:/home/ubuntu# 

root@master:/home/ubuntu# sudo mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.41-0ubuntu0.24.04.1 (Ubuntu)

Copyright (c) 2000, 2025, 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.ubuntu24在线安装mysql

sudo apt update
sudo apt upgrade -y

sudo apt install mysql-server -y

sudo systemctl start mysql
sudo systemctl enable mysql

sudo systemctl status mysql

2.运行安全配置脚本

sudo mysql_secure_installation

根据提示操作：
选择密码强度验证策略（默认按回车跳过）。
设置root用户的密码。
移除匿名用户（Y）。
禁止远程root登录（Y）。
删除测试数据库（Y）。
立即应用更改（Y）。

3.验证MySQL安装

sudo mysql -u root -p

4.配置远程访问（可选）

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

修改：bind-address = 0.0.0.0 # 允许所有IP访问

#创建远程用户并授权：
CREATE USER 'root'@'%' IDENTIFIED BY 'Admin@123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

5.重启MySQL服务

sudo systemctl restart mysql

sudo ufw allow 3306/tcp

6.卸载MySQL（备用）

sudo apt purge mysql-server mysql-client mysql-common -y
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt autoremove -y