Connection coudn't be established to the local hos

rraguraman · February 2nd, 2005, 01:01 AM

Hi All,

I am a newbie trying to use MySQL with java.
I tried out the code was found on the following website

http://www.javacoding.net/articles/t...ava-mysql.html

I tried to run the compiled program with the mentioned arguments.
I am getting the following error. Could any body help me on this?
Many thanks,

Ram

Connection couldn't be established to jdbc:mysql://localhost/test
Exception in thread "main" java.sql.SQLException: Invalid authorization specific
ation message from server: "Access denied for user 'nobody'@'localhost' (using p
assword: NO)"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1997)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1906)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 2520)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:81 7)
        at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1786)
        at com.mysql.jdbc.Connection.<init>(Connection.java:4 50)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:411)
        at java.sql.DriverManager.getConnection(DriverManager .java:512)
        at java.sql.DriverManager.getConnection(DriverManager .java:193)
        at TestMySQL.getConnection(TestMySQL.java:66)
        at TestMySQL.test(TestMySQL.java:20)
        at TestMySQL.main(TestMySQL.java:132)

HumaMunir · February 13th, 2005, 01:42 PM

well... i think it is the problem of the host . it happens when your program runs it tries to eastablish a connection on your computer so 1. whether your connection from sql to your computer is not working or 2. its asking for a host or server. Look at the program where its is assigning the URL with a string (url = "jdbc:mysql://" + host + "/" + database;) here the host is server and you are using your localhost so you can try changing it with the name of your computer.

HumaMunir