LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Closed Thread
  Search this Thread
Old 12-11-2014, 03:19 AM   #1
byran cheung
Member
 
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 config.inc.php and config.php in the server , would advise is there other method that I can get back the password ? thanks
 
Old 12-11-2014, 03:23 AM   #2
lingon
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, 09:34 AM   #3
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,190
Blog Entries: 10

Rep: Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983
https://www.linuxquestions.org/quest...rd-4175527160/
 
Old 12-12-2014, 05:49 AM   #4
angelawinstead
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, 11:12 AM   #5
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,969

Rep: Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115
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 05:57 AM
mysql error while changing mysql password jsaravana87 Linux - Server 5 09-09-2011 12:57 AM
Use PAM for MySQL auth? (I.e., password-less MySQL access?) hydraMax Linux - Security 4 04-05-2011 10:26 PM
Mysql not starting after changing mysql admin password in fedora prastal Linux - Newbie 1 02-20-2010 08:26 PM
LXer: How To Back Up MySQL Databases Without Interrupting MySQL LXer Syndicated Linux News 0 05-14-2007 10:16 AM


All times are GMT -5. The time now is 07:36 PM.

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