Mysql配置远程登录
- 选择mysql库
use mysql;
- 修改访问权限(二选一)
直接修改user表
update user set host='%' where user='root';
设置访问权限语句
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
- 刷新访问权限
flush privileges;
- 查看用户表是否添加成功
select user, host from user where user='root';
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/195aaa6fcc8f5b47deb2fd69d48de6be.png)