[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2014-03-22
8
Medium Priority
?
241 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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

Accepted Solution

by:
mankowitz earned 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

649 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