请问mysql远程连接的问题
我是在win7下安装的wamp。客户端也是win7,也安装了wamp。
我想远程连接到mysql服务器,备份数据。请看我的做法:
1、在服务器端将表mysql.user中的root用户的host字段的值改为%,
update user set host ='%’ where user ='root’;
2、授权为ALL PRIVILEGES
grant all privileges on *.* to 'root'@'%' identified by "password";
flush privileges;
然后在客户端连接(在目录\wamp\bin\mysql\mysql5.6.17\bin下):
mysql -h 192.168.8.119 -P 3306 -u root -p password
可是还会出现:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.8.119' (10060)
请问:还有哪里有问题?怎么才能远程连接mysql服务器?