2025-ubuntu24系统宿主机上在线安装mysql数据库完整演示
目录
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 -ysudo apt install mysql-server -ysudo systemctl start mysql
sudo systemctl enable mysqlsudo systemctl status mysql2.运行安全配置脚本
sudo mysql_secure_installation*根据提示操作：
选择密码强度验证策略（默认按回车跳过）。
设置root用户的密码。
移除匿名用户（Y）。
禁止远程root登录（Y）。
删除测试数据库（Y）。
立即应用更改（Y）。*
3.验证MySQL安装
sudo mysql -u root -p4.配置远程访问（可选）
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;
exit5.重启MySQL服务
sudo systemctl restart mysqlsudo ufw allow 3306/tcp6.卸载MySQL（备用）
sudo apt purge mysql-server mysql-client mysql-common -y
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt autoremove -y