LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 09-12-2003, 12:07 AM   #1
stonegold84
Member
 
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@127.0.0.1' (Using password: YES)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at MyThread.run(ServerTelnet.java:208)
at java.lang.Thread.run(Thread.java:536)


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......
 
  


Reply


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 02:10 PM
What can I get rid of? NKYG Linux - Software 6 06-17-2004 03:19 PM
Get rid of XP Pedroski Linux - Hardware 5 05-25-2004 11:44 AM
How do I get rid of UTC (timezone problem) Baldrick65 Mandriva 2 10-02-2003 08:48 AM
Getting a rid of X AnyoneEB Linux - Software 4 09-24-2002 07:41 PM


All times are GMT -5. The time now is 09:24 AM.

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