Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 09-11-2003, 11:07 PM   #1
Registered: Jul 2003
Location: singapore
Distribution: none
Posts: 53

Rep: Reputation: 15
somebody help me to get rid of this problem

dear all,

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@' (Using password: YES)
at com.mysql.jdbc.MysqlIO.doHandshake(
at com.mysql.jdbc.Connection.createNewIO(
at com.mysql.jdbc.Connection.<init>(
at com.mysql.jdbc.NonRegisteringDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(

i get this error when my java program try to connect to the mysql..

i installed mysql in /usr/bin as i dun know where to install ... i hope the destination folder for installation doesnt matter....

i installed this mysql as root...

i have a user called sara under the root.

i use sun one studio for my java applications .....

this user sara dont have the previliges to access the database..

i referred the mysql documentation, but doesnt help me to sort out .. & itried some commands given by some users in some other threads..

the commands i used to grant access:::

grant select on saravanan.USERS to sara;

flush previliges;

saravanan is the name of the database... USERS is the name of the table which i created under the root account..

grant all privileges on *.* to '@sara'@'%' identified by 'abcd' with grant option;

flush previleges;

the respond i got:

Query OK, 0 rows affected (0.00 sec)

it says 0 rows affected....

how to solve this ?????

can i install mysql again ????? which i feel to be the final solution,,

and if i reinstall the mysql, will there be any conflicts between this mysql & the newer one????

any 1 help me......... this really affects my project work........

i already started another thread but there were no reply after a few posts which dint really helped....

iam a new user & using mandrake linux for past 2 months.... this is my first time in linux....

help plz......


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
where did it come from, and how do i get rid of it? scarryharry Slackware - Installation 2 10-08-2004 01:10 PM
What can I get rid of? NKYG Linux - Software 6 06-17-2004 02:19 PM
Get rid of XP Pedroski Linux - Hardware 5 05-25-2004 10:44 AM
How do I get rid of UTC (timezone problem) Baldrick65 Mandriva 2 10-02-2003 07:48 AM
Getting a rid of X AnyoneEB Linux - Software 4 09-24-2002 06:41 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:50 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration