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

Rep: Reputation: 15
MySQL - Canot reset password


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


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 4 12-19-2014 07:30 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 06:12 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration