mysql开启远程连接
mysql在默认情况下是不允许进行远程访问的,默认情况如下:
1、修改权限,设置mysql密码: grant all privileges on *.* to [email protected]'%' identified by "root";
2、允许任意用户远程连接: update user set host = ’%’ where user = ’root’;
mysql在默认情况下是不允许进行远程访问的,默认情况如下:
1、修改权限,设置mysql密码: grant all privileges on *.* to [email protected]'%' identified by "root";
2、允许任意用户远程连接: update user set host = ’%’ where user = ’root’;