alright So I have several older databases and so on that I want to restore, but I don't know the user name or password on them. How can I retrieve this information. These are from several years ago (about 5-6 years back) can anyone give me some pointers on how to retrieve this information from them.
The password is unrecoverable and is hashed in the users table. Do you have any database access to the server that these are on. The easiest way is to create a new user. Or Update the user information in the users table. This probably requires administrative or root access to do.
well I haven't re-uploaded them to the server just yet. I still have the backups on my HDD. I can re-dump them into a database but I was hoping that I could just recover the info before I re-upload them. but if I can just add another user then that would solve the problem then.
idk if this is what I would do or not, can anyone let me know if this would be the right process to do what I need to do to be able to retrieve the info in the databases that I have... http://www.debianadmin.com/recover-mysql-database-root-password.html