MySQL connection

krReddy · #1 (**permalink**) 07-03-07, 11:09

I have installed MySQL in my machine which is in LINUX .
I am able to connect to MySQL from command line in my machine .

When i tried to connect MySQL from any other applications like DataStudio,DBVisualizer etc it is throwing the following error

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

PHP Code:


			
STACKTRACE:



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

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)

        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)

        at com.mysql.jdbc.Connection.<init>(Connection.java:1485)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:154)

        at NMFL.zk.e(Unknown Source)

I have disabled the firewall in my machine by stopping the IPTABLES using command
/etc/init.d/iptables stop

Kindly suggest me what to do

krReddy · #2 (**permalink**) 07-03-07, 11:17

Some more Info..

When i telnet to the MySQL (telnet localhost 3306)port the below error is thrown

Quote:

Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused

swapnilclarion · #3 (**permalink**) 07-04-07, 01:44

Hi,

Please check configuration file My.cnf, if you have skip_networking in it.
Also check for current user privileges or create new user with all privileges.

Thanks,

Internet Services

Web Development

Digital Marketing

Consumer Tech