Thread

i dont have access to the email i used to register anymore. so how do i login to the system ?

thanks
rudy

It’s basically a matter of a forgotten password and no way to get it back?  If so- the kblog has a method that will work.  In your particular case?  I might just change the email address on your existing user- also via phpmyadmin- and then use the forgotten password.  But either method should do the trick.

Does that make sense?

i dont know how phpmyadmin work. how do i change it there? thanks so much

I may shift over to ‘How to’ as this is not an EE issue per se.  And I’ll need to go pull up phpmyadmin to walk you through it.  But- you’ve got access to it- right?  Go log in and select the EE db- it will then show you a list of all of the tables in that database.  Yell back when you’re on that screen.

there are 68 rows. all starting with exp_

then?

thanks

OK- go down to exp_members and click on ‘Browse’- on mine, it’s that first image.

That should take you into the data for that table.

Scroll down until you find your info- it’s probably id number 1 and likely to be the first one.  Anyway- you’ll see your username listed.  Ignore the password- it’s incrypted.  Trying to use the one you see won’t work.

OK- let me know when you spot it.  Don’t delete anything, don’t edit anything- and if it asks you to confirm something?  Don’t confirm it.

ok i see it and the encryption. bb178042f10555b5eb9192b4133c3a1d2b0

what do i do next Rob ?

thanks 😊

rudy

OK- so you found your row - you should see like a little pencil gif on the left- mouseover says ‘edit’?  You can edit that row.  So, just click the little edit image, it opens all the fields.  Should spot your email in there.  Just go change it to whatever email you want to use and save.

Then- go over to EE and do the ‘forgotten password’ and it will send a new password to the email addy in the database.

(Knowing what the password is in the db doesn’t help- since it’s encrypted.  But you can edit the email addy easily enough.)

Other option was to register as a new member on the frontend, then go into phpmyadmin and change the group id to 1.  Either should work.  But as long as you can figure out how to edit a single record in phpmyadmin, you should be good to go.

Make sense?

i changed it to my email add, click go. but how come its still showing when i use forgot password

“

The email address you submitted was not found in the database.

Submit your email address

“

k i registerd new account and successfully logged in to the admin 😊. thanks so much Rob 😊

rudy

Hiya,

I don’t want to tread on your toes here Robin at all but I was just wondering if anyone ever resets their password the way I do as I find it a lot easier but am just wondering if there is any draw-backs to my method? I can’t think of any though.

The way I do it if I ever do forget a password (although I don’t nowadays as I have a pretty secure system for remembering them but I admit that I used to a while back) is I do pretty much the same thing as said here except I go into the exp_members table via PHPMyAdmin and find the user that I want to edit. I bring up the edit screen for that user and scroll down to their password.

All I do now is type in the password in plain text that I would like it to be and then from the drop-down list to the side of that field choose the encryption method which in my case is always SHA1. This places the password into the database field but encrypts it first as the format that ExpressionEngine needs to work correctly.

Just thought it might help others out in this situation but I am definitely prepared to be told that I shouldn’t do it in that way if there is a good reason not to?
I’ve never had a problem yet though and it is just that little bit quicker so thought I would offer it up to anyone as long as there is no problem with doing it in that way.

Best wishes,

Mark