1. 配置安全组规则

image.png

  1. 常用命令

    1. netstat -anp|grep mysql
    2. find / -name my.cnf
    3. service mysql status/start/stop

  2. mysql的安装过程 ```

    安装过程

    sudo apt-get update sudo apt-get install mysql-server

    查看安装是否成功

    systemctl status mysql

设置过程

以root用户登录mysql sudo mysql -u root -p

设置远程登录用户

方法1 CREATE USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123123’; //修改密码认证方式为mysql_native_password GRANT ALL ON . TO ‘root’@’%’; 方法2 CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123123’; //默认的密码认证插件caching_sha2_password GRANT ALL ON . TO ‘root’@’%’; ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123123’;

修改配置文件 网上查到的大多数修改配置文件路径均说是在/etc/mysql/my.cnf

,但这是对旧版本而已，由于我装的是最新版，所以打开这个文件之后发现里面并没有bind_address这个给值。后来查了一下才发现，新版的是在/etc/mysql/mysql.conf.d/mysqld.cnf。

Instead of skip-networking the default is now to listen only on

localhost which is more compatible and is not less secure.

bind-address = 127.0.0.1 将bind-address注释掉

卸载过程

sudo rm /var/lib/mysql/ -R sudo rm /etc/mysql/ -R sudo apt-get autoremove mysql* —purge ``` 如下图命令显示，才是成功监听外网的mysql连接。
image.png