Cant connect to MySQL server from Java application

Posted by RN on Server Fault See other posts from Server Fault or by RN
Published on 2010-04-03T12:56:00Z Indexed on 2010/04/03 13:03 UTC
Read the original article Hit count: 523

Filed under:
|
|
|
|

This is on VPS\Centos server. The MySQL server is pre configured.

I am running the Java application on Tomcat

My Java web application is not able to connect to the MySQL server.

I get an error -
"Caused by: java.net.ConnectException: Connection refused"

I suspect this to be a configuration problem rather than a coding problem- hence I have posted this on ServerFault
And yes, The same web-app is able to connect to MySQL on a different linux box

This is the URL that I provided to my Java application (note- it assumes default port)

url = "jdbc:mysql://localhost/pickupgames"

My first suspicion was that I am running on a non-default port
So I tried to find the port where mySQL server is running

I tried every trick mentioned in http://serverfault.com/questions/116100/how-to-check-what-port-mysql-is-running-on
But no luck !

SHOW GLOBAL VARIABLES LIKE 'PORT';
This shows port 0

netstat -tlnp doesn't show mysql at all

/etc/my.cnf It has no port entry

telnet localhost 3306 Doesn't connect

And in case you are wondering if mysql server is running at all or not It is And I know for sure, because I have been able to login using the mysql command Also

# ps -ef|grep 'mysql'
root 31839 27662 0 00:49 pts/3 00:00:00 grep mysql
root 32452 1 0 Apr02 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables --skip-networking
mysql 32504 32452 0 Apr02 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock --skip-grant-tables --skip-networking

Please note the --skip-networking parameter
Does this have something to do with the issue ?

Any explanation why I cant connect to mysql server on port 3306 by telnet?

Or why it docent show up under netstat?

Any suggestion on whet I should try next ?

© Server Fault or respective owner

Related posts about mysql

Related posts about vps