I am able to ping both directions from a Linux box to a WinXP box, but
when I try to connect to MySql running on the Linux box using SQuirreL
(a java-based isql tool) using Connector/J 2.0.14 I'm getting the
following exception:
java.sql.SQLException: Cannot connect to MySQL server on
10.12.12.13:3306. Is there a MySQL server running on the machine/port
you are trying to connect to? (java.net.ConnectException)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unk nown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManag er.getConnection(SQLDriverManager.java:124)
at net.sourceforge.squirrel_sql.client.mainframe.acti on.OpenConnectionCommand.execute(OpenConnectionCom mand.java:103)
at net.sourceforge.squirrel_sql.client.mainframe.acti on.ConnectToAliasCommand$SheetHandler.run(ConnectT oAliasCommand.java:371)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter. run(TaskExecuter.java:81)
at java.lang.Thread.run(Thread.java:536)
What I find in the documentation is that there could be a couple of
solutions,
1) firewall issue - I've turned iptables off, so this should be
eliminated
2) server started w/ --skip-networking flag - I've tried starting the
server as a service (I'm not sure what gets executed when this gets
started) and using the command "/etc/init.d/mysql start", which calls
"/usr/bin/mysql --defaults=/etc/my.cnf. My.cnf has no reference to
--skip-netowrking. If there are other suggestions out there I would
be very appreciative.
Thanks.
Jeff