修改mysql遠程連接

--修改用戶遠程連接權限
update user set host = '%' where user = 'root'; 
select host, user from user;
 
--開啟遠程連接
grant all privileges on *.* to 'root' @'%' identified by 'root'; 
flush privileges;
 
注:mysql密碼必須為root