MySql服务器IP是192.168.0.104，测试连接的笔记本IP为192.168.0.100.

以下命令说明两台机器的网络连接是通畅的：

[root@bogon bin]# ping 192.168.0.100

PING 192.168.0.100 (192.168.0.100) 56(84) bytes of data.

64 bytes from 192.168.0.100: icmp_seq=1 ttl=128 time=9.26 ms

64 bytes from 192.168.0.100: icmp_seq=2 ttl=128 time=3.85 ms

64 bytes from 192.168.0.100: icmp_seq=3 ttl=128 time=6.85 ms

64 bytes from 192.168.0.100: icmp_seq=4 ttl=128 time=4.25 ms

64 bytes from 192.168.0.100: icmp_seq=5 ttl=128 time=10.4 ms

64 bytes from 192.168.0.100: icmp_seq=6 ttl=128 time=8.26 ms

64 bytes from 192.168.0.100: icmp_seq=7 ttl=128 time=3.24 ms

64 bytes from 192.168.0.100: icmp_seq=8 ttl=128 time=4.90 ms

64 bytes from 192.168.0.100: icmp_seq=9 ttl=128 time=3.40 ms

64 bytes from 192.168.0.100: icmp_seq=10 ttl=128 time=4.03 ms

64 bytes from 192.168.0.100: icmp_seq=11 ttl=128 time=9.22 ms

64 bytes from 192.168.0.100: icmp_seq=12 ttl=128 time=4.73 ms

64 bytes from 192.168.0.100: icmp_seq=13 ttl=128 time=6.34 ms

64 bytes from 192.168.0.100: icmp_seq=14 ttl=128 time=4.09 ms

--- 192.168.0.100 ping statistics ---

14 packets transmitted, 14 received, 0% packet loss, time 13000ms

rtt min/avg/max/mdev = 3.241/5.919/10.401/2.370 ms

MySQL的配置文件/etc/my.cnf的内容如下：

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

也曾参考网文的做法进行授权，如下

[root@bogon bin]# ./mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on *.* to root@'%' identified by "root";

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

[root@bogon bin]# service mysqld restart

Stopping MySQL:                                            [  OK  ]

Starting MySQL:                                            [  OK  ]

[root@bogon bin]# ./mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant select,update,insert,delete on *.* to root@192.168.0.100 identified by "root";

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql> exit

Bye

授权重启后没有问题。

[root@bogon bin]# service mysqld restart

Stopping MySQL:                                            [  OK  ]

Starting MySQL:                                            [  OK  ]

再看看数据表里面：

[root@bogon bin]# ./mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use ,ysql

ERROR 1049 (42000): Unknown database ',ysql'

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 | 565491d704013245 |

| bogon         | root |                  |

| 127.0.0.1     | root |                  |

| %             | root | 67457e226a1a15bd |

| 192.168.0.100 | root | 67457e226a1a15bd |

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

5 rows in set (0.01 sec)

mysql>

这已经把网文提到的步骤都完成了。

/etc/sysconfig/iptables里3306端口已经打开。

重启mysqld服务后，看看端口情况。

[root@bogon bin]# netstat -tlnpu

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   

tcp        0      0 0.0.0.0:40679               0.0.0.0:*                   LISTEN      1795/rpc.statd      

tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      4107/mysqld         

tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      1776/rpcbind        

tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN      2149/cupsd          

tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      2021/sendmail: acce

tcp        0      0 :::22                       :::*                        LISTEN      1997/sshd           

udp        0      0 0.0.0.0:32768               0.0.0.0:*                               1795/rpc.statd      

udp        0      0 0.0.0.0:32769               0.0.0.0:*                               2130/avahi-daemon:  

udp        0      0 0.0.0.0:679                 0.0.0.0:*                               1776/rpcbind        

udp        0      0 0.0.0.0:703                 0.0.0.0:*                               1795/rpc.statd      

udp        0      0 0.0.0.0:68                  0.0.0.0:*                               1655/dhclient       

udp        0      0 0.0.0.0:5353                0.0.0.0:*                               2130/avahi-daemon:  

udp        0      0 0.0.0.0:111                 0.0.0.0:*                               1776/rpcbind        

udp        0      0 0.0.0.0:631                 0.0.0.0:*                               2149/cupsd 

3306哪一行说明对外网是有端口监听着的。

 

可是，通过DbVisualizer连接失败，报错如下：

Product:  DbVisualizer Pro 9.0.2

Build:  #1912 (2012/12/18 10:21)

Java VM:  Java HotSpot(TM) Client VM

Java Version:  1.6.0_23

Java Vendor:  Sun Microsystems Inc.

OS Name:  Windows 7

OS Arch:  x86

OS Version:  6.1

An error occurred while establishing the connection:

Long Message:

Access denied for user 'root'@'192.168.0.100' (using password: YES)

Details:

   Type: java.sql.SQLException

   Error Code: 1045

   SQL State: 28000

MySql-Front的错误消息如下：

Access denied for user 'root'@'192.168.0.100'(using password:YES)

这已经比前几次有进步了，再查。

偶然间看到了以下网页：

http://bbs.csdn.net/topics/320044602   第43楼，里头提到：

===================================================================================

错误信息 ：ERROR 1045 (28000): Access denied for user 'usera'@'localhost' (using password:YES)

原因 : 用户账号并未创建

检查 ：以管理员ROOT登录后，show grants for 'usera'@'localhost'; 或者 select user from mysql.user; 确认用户账号是否存在。

处理 ：创建用户账号。

===================================================================================

然后又看到了这个网页：

http://www.linuxidc.com/Linux/2008-08/15067.htm ， 里头提到要重设root密码。

两篇网文言下之意似乎都是说root及密码是不对的。

不管了，拣到篮里就是菜，试试看再说。登录104执行以下命令

[root@bogon ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;

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

| Database           |

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

| information_schema |

| mysql              |

| test               |

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

3 rows in set (0.03 sec)

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 user from user

    -> ;

+------+

| user |

+------+

| root |

| root |

| root |

| root |

| root |

+------+

5 rows in set (0.00 sec)

mysql> update user set password=password('12345678') where user='root';

Query OK, 5 rows affected (0.00 sec)

Rows matched: 5  Changed: 5  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

Bye

[root@bogon ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit

Bye

[root@bogon ~]#

然后，没有重启mysqld服务，直接用DBVisualizer，MySQL-Front和SQLToolbox测试，均告成攻。

以下是截图：

如果不是网文提醒，谁知道需要将root密码从原来的123456换到12345678呢，不换还连不上。换了就好了，这就是开门的钥匙。看来这把钥匙早已存在了，只是不了解它而已，了解了，问题也就解决了。

事后综合来看，正确启动，iptables开放3306端口，授权是必要的，重设密码也是必要的，四者在一起为充要条件，缺一不可。数据库客户端软件原来报的错也是对的，只是让人疑惑不去怀疑root和原有密码有问题，因为毕竟是不久前才设置好的.

于是为文，希望能对遇到同样问题的人有所帮助。

《全文完》