Can't figure out how to change password in database

[ifls.inc]

I recently moved my prestashop into my own server. Since then I have not been able to login with the credentials I had setup. I have tried to go into the settings.inc.php to change the password and user but when I go to my store admin it shows an error. I then tried to follow steps shown on various help sites and I can't find the DB NAME in the phpMyAdmin to add cookie key. Can someone please help. Right now I can't access backend of my site.

[selectshop.at]

You cannot change password directly in database. The password is passing through hashing process. You are not able to access cause you destroyed the parity of hash.

Do you have a copy of your /config/settings.inc.php ? If yes you need to copy to your actual /config/settings.inc.php the lines

and uncomment the actual lines.

define('_COOKIE_KEY_', 'xxxxx');
define('_COOKIE_IV_', 'xxxxx');
define('_RIJNDAEL_KEY_', 'xxxxxxx');
define('_RIJNDAEL_IV_', 'xxxxx');

 

Than the parity would be restored. If you cannot access thant you should check if cyphering method is installed and you are using Rijndael.

 

 

[ifls.inc]

So what can I do to change the password or get this fixed? 

[selectshop.at]

I edited my post and added what to do.

[selectshop.at]

BTW, back-office site is blank ? If not and you only forgot your password, you have there a restore option. Try to use it. If not working, than the problem is a different server configuration as old server and the problem is just in this cyphering/hashing located (mcrypt module, PDO driver installed ?)

 

If site is blank, activate debug mode: https://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information-blank-page-500-internal-server-error/

 

[ifls.inc]

I don't have the original settings. I am also not a programmer so I don't know half the terms you stated above..haha.

[selectshop.at]

Who moved the page for you to new server ? This person should have the old files of FTP.

Back-office page is blank, or not ? Can you use the password reset on back-office first page ?

 

I'm also not a programmer.  If you are server admin you should have some basic know-how. Otherwise it is better you contract somebody...

To check if mcrypt is installed: check it with phpinfo. There should mcrypt showing as installed module.

For to check if DbPDO is installed: this is only possible as root user and SSH access with putty for ex. Or if you accessed your back-office on the tab "advanced parameters -> configuration informations"