–修改用戶遠程連接權限
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
只講重點的設計教學,立刻學習網頁教學網誌!
–修改用戶遠程連接權限
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