mysql开启远程访问权限

8.0.1

查看现有用户

select host,user,authentication_string from mysql.user;

新建用户

create user 'mayfly-go'@'172.19.25.168' identified by '123456';

授权

grant all privileges on `mayfly-go`.* to 'mayfly-go'@'172.19.25.168';

查看某个用户的权限

show grants for 'mayfly-go'@'172.19.25.168';

 参考:https://www.cnblogs.com/wuxunyan/p/9095016.html

---

5.7.3

查询用户表命令：

select User,password,Host from mysql.user;

 新增权限用户设置的密码:

GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%' IDENTIFIED BY '123456';

重新加载权限数据:

flush privileges;