Printable View
Hi, i am tried without success many of the suggested solutions to resetting my admin username and password.
i have run this sql command in phyMyadmin:
i still getCode:DELETE FROM admin where admin_id = 1;
INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
Admin Username: Admin
Admin Password: password
"You entered the wrong username or password."
The resend password does not send me another password either..
Please help?
Login with:
Admin
admin
Then reset your email and password ...
This does nothing for me, I still get wrong user name or password error. I am migrating a production system to a new server. The admin login still works on the original server. I cannot login to admin, or upgrade my database because it requires the admin section user name and password.
Did you import your database yet?Quote:
Originally Posted by fdinoto
Do your configure.php files have the same DB_PREFIX settings, or are they different between old/new? They must match or you won't be able to connect to the right security table, and thus the passwords you enter won't match.
the DB is connected and functioning as far as i can tell. the store looks exactly how it does on the original server. it displays products and the cart apears to function properly when i placed a test order. it even sends me confirmation emails.
my DB_PREFIX is blank. as far as i know a prefix isnt required. zencart has the entire database to itself.
I was thinking that maybe the password reset user/pass is different on version 1.2.6 (my version) than the current? although i would sure like to log in using the username and password that is supposed to work right now. passwords are stored encrypted in the database right, does that mean that they can be lost when doing a .sql dump?
thank you
Yes that worked thanks. I reset my password to demo mode and then changed it to something more secure via the Admin section which I now have access to. Thanks again.
guys this is the error I get when running the uninstall.sql for google site map in phpmyadmin:
ERROR
SQL query:
SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google XML Sitemap'
LIMIT 1 ;
MySQL said:
#1146 - Table 'xxxx_zc1.configuration_group' doesn't exist
This is what I get when I try to install in my php:
ERROR
SQL query:
SELECT ( @configuration_group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'Google XML Sitemap'
LIMIT 1 ;
MySQL said:
#1146 - Table 'xxx_zc1.configuration_group' doesn't exist
I had a site up and running on via my personal computer and then i tried creating a second separate site. the second site installed correctly and i decided to scrap it but when i try to log into my first site the login name/pw for the admin controls are not being accepted. this quote sounds like something that i should pay attention to but i dont know what to do. help?!
Quote:
Originally Posted by DrByte
:clap:
I managed to find a fairly simple way - i hope this is correct it worked for and hasn't had any side effects ...so far
I simply went into the MYSQL
and clicked on the passwords table on the right hand side and pressed browse in the php my admin
I saw the passwords for the other two admin names already been set up and they were different to the ones I'd chosen so i inserted a new user and used a different email address and password in case
the bottom field was left as '1' the previous email that didn't work were set to '0' was this the main problem?
Not sure but the new user is now working and we're making changes to the site.