1. 创建用户，使其能远程登录

      1. mysql> create user root@'%' identified by '123456';
      2. mysql> grant all privileges on . to root@'%';
      3. mysql> flush privileges;

    2. 使用sql工具登录数据库，并且创建数据库，表等

    image.png

    1. create database d1;
    2. use d1;
    3. create table t1(id int);
    4. insert into t1 values(1);
    5. insert into t1 values(2);
    6. insert into t1 values(3);
    7. select * from t1;

    完成