关于连接 VirtualBox NAT 下的 MySQL 服务

这两天尝试外部连接 VirtualBox 中 CentOS 的 MySQL 服务器，可谓历尽一番辛苦。

最开始用的是 Java 的 mysql 驱动连接，无奈连接不上。然后下载 SQLyog 的 Community 版进行连接，依然难以通过。

于是开始此次的辛苦旅程。

1 首先想到的 MySQL 服务本身设置的问题。

问题何在呢，端口 or IP？检查尝试设置之后，无论是port forwarding 还是 bind-address，问题依旧。

之后尝试修改MySQL的用户访问控制。

GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'root'; 

继续测试：

mysql:
     [echo] running
     [java] ......
     [java] Error
     [java] com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
     [java]
     [java] ** BEGIN NESTED EXCEPTION **
     [java]
     [java] com.mysql.jdbc.CommunicationsException
     [java] MESSAGE: Communications link failure due to underlying exception:
     [java]
     [java] ** BEGIN NESTED EXCEPTION **
     [java]
     [java] java.io.EOFException
     [java]
     [java] STACKTRACE:
     [java]
     [java] java.io.EOFException
     [java]     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
     [java]     at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:557)
     [java]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1027)
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:620)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:200)
     [java]     at org.huys.db.MySQLConnect.main(Unknown Source)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:616)
     [java]     at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]     at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]     at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)
     [java]     at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)
     [java]     at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132)
     [java]     at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105)
     [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
     [java]     at sun.reflect.NativeMeth