当我的mysql 本地可连接，远程无法连接时

      解决办法如下：

      mysql> use mysql;  
    Reading table information for completion of table and column names  
    You can turn off this feature to get a quicker startup with -A  
      
    Database changed  
    mysql> select host, user, password from user;  
    +-----------+------------------+-------------------------------------------+  
    | host      | user             | password                                  |  
    +-----------+------------------+-------------------------------------------+  
    | localhost | root             |                                           |  
    | sean      | root             |                                           |  
    | 127.0.0.1 | root             |                                           |  
    | ::1       | root             |                                           |  
    | localhost | debian-sys-maint | *0AA379AB8AFD785B32D661A07E9D5C7A24E3B186 |  
    +-----------+------------------+-------------------------------------------+  
    5 rows in set (0.00 sec)  
      
    mysql> update user set host = "%" where host = "sean" and user = "root";  
    Query OK, 1 row affected (0.00 sec)  
    Rows matched: 1  Changed: 1  Warnings: 0  
      
    mysql> flush privileges;  
    Query OK, 0 rows affected (0.00 sec)  
      
    mysql> select host, user, password from user;  
    +-----------+------------------+-------------------------------------------+  
    | host      | user             | password                                  |  
    +-----------+------------------+-------------------------------------------+  
    | localhost | root             |                                           |  
    | %         | root             |                                           |  
    | 127.0.0.1 | root             |                                           |  
    | ::1       | root             |                                           |  
    | localhost | debian-sys-maint | *0AA379AB8AFD785B32D661A07E9D5C7A24E3B186 |  
    +-----------+------------------+-------------------------------------------+  
    5 rows in set (0.00 sec)  

    2.给所有的数据库授权。让当前用户连接。

  grant all privileges on *.* to 'root'@'192.168.1.66' identified by '123456';

     然后搞定了 所有的ip都可以连接了。