PDA

View Full Version : Login doesn't work after moving DB


xspoof
25th October 2008, 07:44 PM
hi icefire,

i had to move one site to another server. script works, but i can't login into admin-panel.

how can i reset the password? I'm using Version 4.1.1

ICEFIRE
26th October 2008, 11:55 AM
You need phpmyadmin or any other mysql interface that will alow you to run SQL commands:

Run this SQLY query:

UPDATE cjoverkill_settings SET login='admin', passwd=PASSWORD('admin');

Then login as admin // admin

This login problem happens when you change MySQL major versions (from MySQL 4 to MySQL 5 for example) because of a significative change in the MySQL password handling routines.

xspoof
26th October 2008, 03:32 PM
Thanks. :)