Solved

I forget the other usernames/passwords so I would like to restore if possible

Posted on 2014-03-22
8
227 Views
Last Modified: 2014-03-30
I am doing 2 php tutorials which have different databaseName/userName/userPassword but still use localhost

I all the databaseNames have been restored with access for user 'root'
I forget the other usernames/passwords so I would like to restore if possible

related question:
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28394911.html

I retrieved databases from wamp upgrade then restore
by copying
\data\mysql\
into current \data
0
Comment
Question by:rgb192
  • 4
  • 4
8 Comments
 
LVL 24

Expert Comment

by:mankowitz
ID: 39948607
First, make sure that the new user table is present. Do this

select * from mysql.user

This should give you a list of users with hashed passwords. The hard part is that the hashed passwords may not work on a new installation, if the password() function is different.
0
 

Author Comment

by:rgb192
ID: 39948656
only root
0
 
LVL 24

Expert Comment

by:mankowitz
ID: 39948693
so it didn't bring the tables across.

See if you have a directory from the old installation, something like this

C:\wamp\bin\mysql\mysql5.1.53\data\mysql

In there should be files like

user.frm
user.myd
user.myi

copy those to the new installation and see if it works.
0
 

Author Comment

by:rgb192
ID: 39948755
user.frm
user.myd
user.myi

are already in

C:\wamp\bin\mysql\mysql5.6.12\data\mysql



I can only find user.xxx in this one location

so I may have copied already from old to new

I do not know the exact steps I took in the previous question
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 24

Accepted Solution

by:
mankowitz earned 500 total points
ID: 39950135
the username data is stored in those files. If you search your whole disk and the user.xxx files only exist in your current installation, then they are lost (unfortunately).
0
 

Author Comment

by:rgb192
ID: 39951835
well I have the files.  how can I read these files
0
 
LVL 24

Expert Comment

by:mankowitz
ID: 39952022
you need mysql to read them (you can pop them into a hex editor, but it may be difficult).

1. make a backup
2. stop the server
3. copy the old files on top of the new ones
4. start the server (fingers crossed)
0
 

Author Closing Comment

by:rgb192
ID: 39964920
lost

Thanks
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now