ubuntu系统下安装配置 8.0.37的MySQL

ubuntu系统下安装配置MySQL 8.0.37-0ubuntu0.22.04.3服务

1. 安装mysql

sudo apt update
sudo apt install mysql-server
sudo systemctl status mysql

2. 进入mysql，创建特定用户，专门用于登录

sudo mysql;
create user 'user_name'@'ip_address' identified by "password";
grant all ON database_name.* to user_name@'ip_address' with grant option;

3. 修改mysql的配置文件(/etc/mysql/mysql.conf.d/mysqld.cnf)

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address = 0.0.0.0，并保存退出

4. 重启mysql服务

sudo systemctl restart mysql

5. 如果ufw是活跃状态的话，得开启3306端口，如果不是活跃状态就可以跳过了

sudo ufw allow 3306/tcp

6. 如果云服务器的话记得在安全组中放行3306端口
7. 客户端测试连接MySQL服务器

参考文献

https://www.myfreax.com/how-to-install-mysql-on-ubuntu-22-04/