• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access denied error ....MySQL

 
Balamurugan ponnambalam
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am getting the following error message while connecting with the MySQL .(O/S :Sun OS 5.6)
Error.....java.sql.SQLException: Invalid authorization specification: Access denied for user: 'some_user&password@localhost' (Using password: NO)
Note that i have given all permission to the user using,
GRANT ALL PRIVILEGES .......................
The code i have used to connect with the database is,
import java.io.*;
import java.sql.*;
class test
{
public static void main(String a[])
{
try
{
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection(jdbc:mysql://localhost/db_name?user=some_user&password=some_pass");
stmt=con.createStatement();
//do something with resultset
}
catch(Exception e)
{
System.out.println("Exception in second try.."+e);
}
}
}
plese guide me on this problem to solve.
Thankz,
Bala.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic