LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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 10-10-2005, 05:46 PM   #1
texmansru47
Member
 
Registered: Jul 2004
Location: Texas
Distribution: CentOS 4.X
Posts: 42

Rep: Reputation: 15
MySQL - Canot reset password


All,

I have a strange problem. I setup mysql with two password access for the root command (localhost and the DNS name). Of course the DNS name works, but I need the localhost to work. I have been trying the standard methods of resetting this password:

1. killall mysqld
2. ./mysqld start --skip-grant-tables -user=root
3. OR ./mysqld start -Sg --user=root &

When I try to run mysql -u root to get the clean access so I can update the password, I still get the deny of access menssage:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


This is killing me. Any other suggestions? I even tried the resolution from the MySQL Administrator support page, where you delete the .pid file assoicated to that mysql installation and then try and reset the password that way, but no dice.

There has to be a resolution for this issue.

Thanks in advance.
 
Old 10-10-2005, 06:19 PM   #2
DrOzz
Senior Member
 
Registered: May 2003
Location: Sydney, Nova Scotia, Canada
Distribution: slackware
Posts: 4,185

Rep: Reputation: 59
maybe this can help you, a little article written by a LQ member :
Click Here To View
 
  


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
mysql: still can't login after root password reset andredude Linux - Software 3 12-27-2012 10:48 PM
reset root password kapslock Debian 14 07-27-2006 08:08 AM
Password reset hongman Linux - Newbie 2 07-11-2005 06:46 AM
Password won't reset with Mdk 10.1 linubex Mandriva 22 06-24-2005 07:44 AM
reset the password ust Linux - General 1 02-11-2004 07:35 AM


All times are GMT -5. The time now is 05:07 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration