Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


Closed Thread
  Search this Thread
Old 12-11-2014, 02:19 AM   #1
byran cheung
Registered: Sep 2013
Posts: 321

Rep: Reputation: Disabled
how to get back mysql password

I would like to get back a user mysql password ( not root user ) , I do not want to reset the password , just would like to know the password , I can't find the file and config.php in the server , would advise is there other method that I can get back the password ? thanks
Old 12-11-2014, 02:23 AM   #2
LQ Newbie
Registered: Apr 2014
Posts: 5

Rep: Reputation: Disabled
Hello byran,

Your password is hashed in "one-way" so if you don't have any documentation or configuration containing the password it's irretrievable.
You can however reset your password by login in with the root account or running MySQL without permissions loaded.

Best regards
Old 12-11-2014, 08:34 AM   #3
LQ 5k Club
Registered: Jan 2011
Location: Nowhere near you, thank God.
Distribution: OSX Sierra
Posts: 8,568
Blog Entries: 14

Rep: Reputation: Disabled
Old 12-12-2014, 04:49 AM   #4
LQ Newbie
Registered: Dec 2014
Posts: 2

Rep: Reputation: Disabled
I think it is better to reset your password, it is bit difficult to recover your old one.
Old 12-19-2014, 10:12 AM   #5
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 12,432

Rep: Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312Reputation: 3312
Please post your thread in only one forum. Posting a single thread in the most relevant forum will make it easier for members to help you and will keep the discussion in one place. This thread is being closed because it is a duplicate.

Closed Thread

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: debian-sys-maint password changed by accident, possible to change it back? ldp Linux - Software 7 08-29-2014 04:57 AM
mysql error while changing mysql password jsaravana87 Linux - Server 5 09-08-2011 11:57 PM
Use PAM for MySQL auth? (I.e., password-less MySQL access?) hydraMax Linux - Security 4 04-05-2011 09:26 PM
Mysql not starting after changing mysql admin password in fedora prastal Linux - Newbie 1 02-20-2010 07:26 PM
LXer: How To Back Up MySQL Databases Without Interrupting MySQL LXer Syndicated Linux News 0 05-14-2007 09:16 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:27 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