Display userids/passwords using PHPMYADMIN

[JasonFarmer]

Im sorry guys I wont pretend to know much about databases. I just spent the day setting up a website, 7 hours of work and I decided to change the default password which is stored in a MYSQL database and something went wrong.

Now I cant login to my site, I can access my database through PHP

I have a table called dir_admins and a field called Name and one called password is there a way to see whats in there or better yet change the info?

[ronverdonk]

Instead of trying to remember whatever you did and what you changed it into, just re-install MySQL server. Takes 30 minutes and that time is a lot shorter than trying to break a table of which the password is probably encrypted anyway.

Ronald :cool:

[JasonFarmer]

Its not the password to MYSQL that I lost, its a password in MYSQL for a website there has to be a query or something to find it if its in there right?

[ronverdonk]

When you can access the db, you should be able to issue the

SELECT Name, password FROM dir_admins

command.

Hwoever, a password is usually stored using some encryption scheme, like PASSWORD() or SHA1() or MD5(). When that is the case, you won't be able to de-crypt it.

Why don't you just add the same userid and a new password to that (user)
table?

Btw: this is a MySQL problem so I'll move the thread to the MySQL forum.

Ronald :cool:

[JasonFarmer]

When you can access the db, you should be able to issue the

SELECT Name, password FROM dir_admins

command.

Hwoever, a password is usually stored using some encryption scheme, like PASSWORD() or SHA1() or MD5(). When that is the case, you won't be able to de-crypt it.

Why don't you just add the same userid and a new password to that (user) table?

Ronald :cool:

Thanks that returs an empty result, which probably means while I was editing my site I screwed up. Are you able to tell me how I could add a new name and password? Thanks a lot for your help

[wchill86]

Your title suggests your using phpmyadmin, if so you should be able to go into the database itself and view the log in table and going through those options (dont remember exactly which to pick) you can find the log in and passwords for all registered members including admin.