rgb192
asked on
I forget the other usernames/passwords so I would like to restore if possible
I am doing 2 php tutorials which have different databaseName/userName/user Password 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:
https://www.experts-exchange.com/questions/28394911/data-from-mysql.html
I retrieved databases from wamp upgrade then restore
by copying
\data\mysql\
into current \data
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:
https://www.experts-exchange.com/questions/28394911/data-from-mysql.html
I retrieved databases from wamp upgrade then restore
by copying
\data\mysql\
into current \data
ASKER
only root
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\m ysql
In there should be files like
user.frm
user.myd
user.myi
copy those to the new installation and see if it works.
See if you have a directory from the old installation, something like this
C:\wamp\bin\mysql\mysql5.1
In there should be files like
user.frm
user.myd
user.myi
copy those to the new installation and see if it works.
ASKER
user.frm
user.myd
user.myi
are already in
C:\wamp\bin\mysql\mysql5.6 .12\data\m ysql
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
user.myd
user.myi
are already in
C:\wamp\bin\mysql\mysql5.6
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
well I have the files. how can I read these files
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)
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)
ASKER
lost
Thanks
Thanks
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.