• 1 修改localhost
• 2 配置/etc/mysql/my.cnf
• 3 其他

• 更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%"

mysql>use mysql;

mysql>update user set host ="%" where user = "root";

mysql>select host, user from user;

mysql>FLUSH PRIVILEGES;

• 这时的user表应该是这样的

mysql> select * from user;

+-----------+------------------+-

| Host      | User             |

+-----------+------------------+-

| %         | root             |

| debian    | root             |

| 127.0.0.1 | root             |

| ::1       | root             |

| %         |                  |

| debian    |                  |

| %         | debian-sys-maint |

+-----------+------------------+-

7 rows in set (0.00 sec)

查看/etc/mysql/my.cnf中,skip-networking 是否已被注掉 sudo gedit /etc/mysql/my.cnf

原：

#

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address    = 127.0.0.1

#

改为：

#

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

# bind-address    = 127.0.0.1

#

1 Mysql的端口是否正确

通过netstat -ntlp查看端口占用情况，一般情况下端口是3306。在用工具连接MySQl是要用 到端口。例如My Admin\My Query Browser\MySQl Front等。

2 查看iptables是否停掉,没关的情况下,无法连接

通过：service iptables stop临时关闭 报错：ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.51.112' (113)