安装mysql8

安装mysql

# 安装之前更新一下apt
sudo apt update
# 安装
sudo apt-get install mysql-server

设置密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '999999';

设置mysql允许远程访问

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1

使用mysql 数据库

mysql > use mysql;

特定用户的host 修改

mysql > update user set host='%' where user='root';

指定用户的授权

mysql > grant all privileges on test.* to root@'%'