[Solved]Changing password in phpMyAdmin

[jasnick]

Using 1.10.1

Just transferred a site from a test directory to its proper place and now cannot access admin. Site is online OK but think its still showing from the test directory.

When I try to get into Admin I get an incorrect username or password message. User is admin - tried new password and test directory password and neither works. Looking at it in phpMyAdmin the very long string password seems to be the same for both installations.

Can I get in if I change the password in phpMyAdmin? I have read how to do this but couldn't really understnd the instructions. Got as far as clicking on edit and edit inline, but what next. Just deleting and putting in a new password didn't work.

Is there a specific way to do this? Not technical so I would be grateful if someone could please be very specific with instructions.

Thanks.

[calguy1000]

Is this a fresh install of 1.10 or did you upgrade from 1.9.x

This is important because if it was a fresh install of 1.10, unless you actually unchecked the 'salt passwords' checkbox... there is nothing simple you can do to reset the password.

Do you have the email that CMSMS sent you with the username and password when you did the initial install? did you click the checkbox to send it?

[calguy1000]

follow up: Even if you didn't click the button for the CMSMS Installer to send you an email, if you put your email address in... you should be able use the password reset functionality. Even if this was an upgrade from 1.9.x to 1.10.

[jasnick]

Thanks for quick reply calguy.

Both sites are fresh installs

unless you actually unchecked the 'salt passwords' checkbox... there is nothing simple you can do to reset the password.

1.10.1.

What is the "salt passwords" checkbox ?????????????????

Yes, I have both emails, from the test directory and the newsite directory.

I have got to sort this out quickly. Its a very small site. Might it be best to just start again and set it up in its proper place to beign with instead of in the test directory ?

Your latest - password reset didn't work either!

Thanks

[calguy1000]

Snapshot of the form attached.

If you are getting the 'Incorrect Username or Password' message then it has to be something very simple that you have done.

[jasnick]

I have never seen that form before? Where does it come from?

[calguy1000]

Step 4 of the CMSMS installation procedure.

[jasnick]

I have never seen that form before? Where does it come from?

I install CMSMS via Softaculous in the cpanel of whatever site I am working on.

Then I go into the bit that finishes the install and it goes through several steps which I don't recall ever having to do anything with. Everything seems to be ticked so I just click on continue until it finishes.

Edit: started over and got it done.

For future reference, is there some other way I should be installing CMSMS?

Thanks

[RonnyK]

Depends on what you want. Salt is a kind of irreversable method of storing passwords.

With the tick for Salt set on installation, there is no quick way to handle the phpmyadmin modification of the password, which is kind of the intention of the Salting.

If you have access to the phpmyadmin, you could store the mail-address in the user-table for your user, and use the lostpassword link in the login-screen to get the recovery-mail send to you.

Best way is to key in a valid mail-address when installing and setting up the admin-user, to always be able to send lostpassword messages. If you dont set it during installation, just set it after installation in the usersettings.

Ronny

[jasnick]

Thanks Ronny - I do set the email during setup. This installation seemed doomed from the start. I suspect a file or two failed to upload and my trying to fix it made it worse. Anyway, all good now.