MySQL Communications Error between application server and MySQL server

[Will Barbee]

I have an application where the software runs on server 1 and the MySQL database is on server 2.
When I run the application directly on server 2, it runs properly.
When I run it from server 1 I get a database connection error:
"Failed to get database connection.
Communication exception - Communication link failure -
The last packet sent successfully to the server was 0 ms ago.
The driver has not received any packets from the server."

The Java code is:

	strDBClass = "com.mysql.jdbc.Driver";
	strDBName = "jdbc:mysql://greymatter/AtndPlus?user=AtdPls&password=Attend";
    	try {
		Class.forName(strDBClass).newInstance();
	} 
	catch (Exception e) 
	{
		ErrMsg = "Atnd Did not load JDBC/ODBCDriver./" + e;
		Atd_XMessge doAMsg1 = new Atd_XMessge();
		doAMsg1.Atd_XMessge(entClFt2, ErrMsg, jfAnc2);
		chrErr = 'Y';
		return;
	}

    	try {
		AtdConn = DriverManager.getConnection(strDBName);
		Atd_Atnd = AtdConn.createStatement();
	} 
	catch (Exception e) 
	{
		ErrMsg = "Atnd Failed to get DB connection./" + e;          // <<<<This is the error produced
		Atd_XMessge doAMsg2 = new Atd_XMessge();
		doAMsg2.Atd_XMessge(entClFt2, ErrMsg, jfAnc2);
		chrErr = 'Y';
		return;
	}

We believe it is because the Windows Firewall is on. The client does not want to run without the firewall.

Does anyone know the name of the program doing the communicating so we can tell the Windows firewall that it is a trusted program?

I know the names and classes I put in the connection statements but I would not expect those to be the name
of the program which does the actual connecting.>

[Vijitha Kumara]

Have you tried opening the port (3306 default/the port MySQL runs) on the firewall? That would be a security issue of course.

[Tom Reilly]

Googling "windows mysql process name" came up with some possiblities.