MySQL connection refused::

[macawgumbo]

I am trying to connect from my Windows laptop via Zend Studio 5.0 Enterprise to my Gentoo Linux Server and MySQL 4.0.x install. The server is working locally (eg. phpmyadmin works fine and so does logging in at the prompt). However, it does not accept connections remotely as the Zend Studio attempt is replied with connection refused. Any ideas? I have added a user with full privileges on all tables from all login places. Still doesn't work.

[psycepa]

does your server accept connection from other hosts ? what do you have in /etc/hosts.allow and /etc/hosts.deny ?

[macawgumbo]

have not edited hosts.allow or hosts.deny. I found the workaround for my problem though. I am developing on a WinXP machine and found WAMP which installs the latest versions of apache mysql and php in one simple installshield wizard. Now I am using Zend Studio to develop and connect to the local mysql db. I edit hosts.allow now.

[rojanu]

I have the same problem here trying to use mysql on a gentoo box from winXP using mysql-jdbc driver the error I get is

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2592)
at com.mysql.jdbc.Connection.<init>(Connection.java:1509)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at main.data.UserDa.initialize(UserDa.java:38 )
at main.data.User.initialize(User.java:35)
at main.MainExecuter.initialise(MainExecuter.java:17)
at main.MainExecuter.main(MainExecuter.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:86)


** END NESTED EXCEPTION **



Last packet sent to the server was 31 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2658)
at com.mysql.jdbc.Connection.<init>(Connection.java:1509)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at main.data.UserDa.initialize(UserDa.java:38 )
at main.data.User.initialize(User.java:35)
at main.MainExecuter.initialise(MainExecuter.java:17)
at main.MainExecuter.main(MainExecuter.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:86)

code trying to access mysql

Code: Select all

public static void initialize() throws Exception
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			dbcon = DriverManager.getConnection("jdbc:mysql://192.168.1.159:3306/blue","user","password");
			statement = dbcon.createStatement();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

Any ideas!!

[magic919]

1. Start a new thread.

2. Check netstat -tunlp and make sure MySQL is listening on 3306.

3. Check my.cnf and read comments if not.