JAVA连接MYSQL问题?

[zwl000906]

url="jdbc:mysql://127.0.0.1/logsys",可以正常了连接,
但url="jdbc:mysql://192.168.16.17/logsys"就连接不上了,提示"Host is not allowed to connect to this MySQL server",请高手赐教,急!!!

[zwl000906]

192.168.16.17是我自己的IP

[loveflea]

mysql中你没有给host为'192.168.16.17'的用户授予访问权限,在mysql中执行：

GRANT ALL PRIVILEGES ON logsys.* TO 'logsys'@'192.168.16.17' IDENTIFIED BY 'password';

[zwl000906]

问题发现了,没有为"192.168.16.17"的主机名