iam unable to connect to mysql database.iam getting the following error when iam running the program. Exception in thread "main" java.sql.SQLException: Access denied for user: 'root@ localhost' (Using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1229) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544) at com.mysql.jdbc.Connection.<init>(Connection.java:1474) 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 DBTest.main(DBTest.java:13) plezz help me n this regard bye seenu
Maximilian Xavier Stocker
Joined: Sep 20, 2005
The password supplied was incorrect or you don't have permission to login as root from "localhost". Note that to MySQL "localhost" is a hostname and is not the same as the actual name of your machine. You shouldn't be loggin in as mysql root anyway.
Create a new user. Make sure to specify which hosts the user can connect from.