实现远程登陆
修改mysql数据库的user表
update user set host = '%' where user = 'root';
修改远程后本地无法登陆
为需要远程登录的用户赋予权限:
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
最后记得 flush privileges;
实现远程登陆
修改mysql数据库的user表
update user set host = '%' where user = 'root';
修改远程后本地无法登陆
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
最后记得 flush privileges;