Unable to reset admin password in phpmyadmin…

[eranariel]

This is a continuation of the technical problem I have described in the following thread:
http://www.zen-cart.com/forum/showthread.php?t=178759
I think that I have been able to better isolate the problem for which I need a solution.
I moved my store to a new server – same host, however, on a server located in another geographic location.
I followed the instructions: http://tutorials.zen-cart.com/index.php?article=100 regarding moving the server: I manually adjusted the configure.php files, successfully ran the Fix_Cache_Key, and accordingly removed it from the server as per the instructions.
The problem, however, seems not with moving to the new server but with accessing the admin… I need to reset the password, however, I am unable to do so in phpmyadmin..
I followed the instructions in:http://tutorials.zen-cart.com/index.php?article=2 However, to no avail. #1146 - Table 'eranariel.admin' doesn't exist - This seemed quite puzzling, therefore, I tried to test this with my old installation (that is still up and running) and I received the exact same error and my previous name - password remained in tack with the previous installation.

[stevesh]

Does that table (eranariel.admin) in fact exist ? Are you using that table prefix in either site ?

[eranariel]

Thanks for the reply... I am not using any prefixes such as that one...

it seems as if this table does not exist... let me check again, however, MySQL provided me with a message that it does not exist..

[stevesh]

It sounds like you added that prefix to the SQL query outlined in the tutorial, and since you aren't using a prefix, it can't find that table. Make sure it just says admin in the query.

[eranariel]

Thanks Steve,

This is an enigma... exactly where can I remove this prefix...
I cannot see it in any of the tables... I'll check again...

Eran

[stevesh]

My thinking was that you may have once used a prefix and had modified the SQL query in the tutorial you mentioned to include it:

"If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
ie. "... FROM/INTO prefix_admin ...".

[eranariel]

I am still not sure that I understand...all of the prefixes in are Zen_
or something in that context... where should I look in my database?

Eran

[eranariel]

OK... I got it...

I was not sure where to place the prefix in the SQL query


DELETE FROM zen_admin WHERE admin_name = 'Admin';
INSERT INTO zen_admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);