1.卸载mysql
sudo apt purge mysql-*
sudo rm -rf /etc/mysql/ /var/lib/mysql
sudo apt autoremove
sudo apt autoclean
2.安装
使用apt安装
sudo apt-get install mysql-server -y
修改root密码：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'passwd';
3.配置用户
添加用户：
CREATE USER 'dev_test_1'@'host' IDENTIFIED BY 'password';
赋予权限：
GRANT ALL PRIVILEGES ON . TO 'dev_test_1'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION;
指定数据库权限：GRANT all PRIVILEGES on iscp.* to 'dev_test_1'@'%';
查看权限：show grants for 'dev_test_1'@localhost;
刷新权限：flush privileges;
查看权限
首先登录mysql：mysql -u root -p
使用mysql库：use mysql;
查看权限：select user,host from user;
4.远程登录
注意远程登录的user、host需要有对应的权限和可访问的地址
修改配置文件：
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉：bind-address = 127.0.0.1
