MySQL开启远程连接,需修改mysql数据库里的user表,如下所示:
mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>flush privileges; /*使修改的生效,要执行此语句,不然要重启MySQL*/
MySQL开启远程连接,需修改mysql数据库里的user表,如下所示:
mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>flush privileges; /*使修改的生效,要执行此语句,不然要重启MySQL*/