修改mysql远程连接_MySQL:bitsCN.com --修改用户远程连接权限update user set host = '%' where user = 'root'; select host, user from user; --开启远程连接grant all privileges on *.* to 'root' @
导读修改mysql远程连接_MySQL:bitsCN.com --修改用户远程连接权限update user set host = '%' where user = 'root'; select host, user from user; --开启远程连接grant all privileges on *.* to 'root' @
bitsCN.com
--修改用户远程连接权限 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 bitsCN.com
修改mysql远程连接_MySQL
修改mysql远程连接_MySQL:bitsCN.com --修改用户远程连接权限update user set host = '%' where user = 'root'; select host, user from user; --开启远程连接grant all privileges on *.* to 'root' @
