解决MySQL的远程连接

方法一
1、d:\mysql\bin\>mysql   -h   localhost   -u   root;  //这样应该可以进入MySQL服务器

2、mysql>GRANT   ALL   PRIVILEGES   ON   *.*   TO   'root'@'%'   WITH   GRANT   OPTION;  //赋予任何主机访问数据的权限

3、mysql>FLUSH   PRIVILEGES;  //修改生效

4、mysql>EXIT;  //退出MySQL服务器

方法二
1、修改localhost
更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%" 
mysql>use mysql; 
mysql>update user set Host = '%' where Host = 'localhost'; 
mysql>select host, user from user;
mysql>FLUSH PRIVILEGES;

grant select,update,insert,delete on *.* to duan@'%' identified by "123456";
FLUSH   PRIVILEGES;  

mysql>update user set Host = '%' where Host = 'localhost';