系统信息

Distributor ID: Ubuntu
Description:    Ubuntu 24.04.3 LTS
Release:        24.04
Codename:       noble

安装

sudo apt update && sudo apt install -y mysql-server

配置

1. 使用管理员权限进入, 默认密码为空

   sudo mysql -uroot -p -e "
   # 修改认证插件为不需要密码的方式, 仅针对MySQL 8.0 及以上版本
   ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;
   # 创建可以用于远程登录的root用户, 同时设置密码
   CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Yanwei_2019.';
   # 授予所有访问权限
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   "
   

2. 确认安装的版本及上一步执行情况

   sudo mysql -uroot -p -e "select version();select user,host from mysql.user;"
   

   输出如下:

   +-------------------------+
   | version()               |
   +-------------------------+
   | 8.0.43-0ubuntu0.24.04.1 |
   +-------------------------+
   +------------------+-----------+
   | user             | host      |
   +------------------+-----------+
   | root             | %         |
   | debian-sys-maint | localhost |
   | mysql.infoschema | localhost |
   | mysql.session    | localhost |
   | mysql.sys        | localhost |
   | root             | localhost |
   +------------------+-----------+
   

3. 允许外部访问

   默认绑定本地IP(127.0.0.1), 改为0.0.0.0

   sudo sed -i 's/^bind-address[[:space:]]*=[[:space:]]*127.0.0.1/bind-address            = 0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf
   sudo systemctl daemon-reload
   sudo systemctl restart mysql