mysql安装

安装mysql
sudo apt-get install mysql-server
sudo mysql_secure_installation 配置mysql密码

1、修改配置文件
vim /etc/mysql/my.cnf 进入

2、修改配置文件为：
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
port=3306
bind-address=0.0.0.0
mysqlx-bind-address = 0.0.0.0

3、创建数据库
mysql -u root -p 进入mysql
create database user; 创建库
show databases; 显示所有库

4、修改密码等级：
set global validate_password.policy=LOW;
set global validate_password.length=1;

5、修改密码和权限：
create user root@‘%’ identified by ‘123456’;
grant all privileges on . to root@‘%’ with grant option;
FLUSH PRIVILEGES; 刷新权限

6、设置远程访问
mysql -u root -p 进入mysql
use mysql;
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES; 刷新权限

7、允许防火墙通过3306端口（如果需要）
sudo ufw allow 3306/tcp