Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    red flag Unable to reset admin password in phpmyadmin…

    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: https://www.zen-cart.com/tutorials/i...hp?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:https://www.zen-cart.com/tutorials/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.

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Unable to reset admin password in phpmyadmin…

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

  3. #3
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    Default Re: Unable to reset admin password in phpmyadmin…

    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..

  4. #4
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Unable to reset admin password in phpmyadmin…

    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.

  5. #5
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    Default Re: Unable to reset admin password in phpmyadmin…

    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

  6. #6
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Unable to reset admin password in phpmyadmin…

    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 ...".

  7. #7
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    Default Re: Unable to reset admin password in phpmyadmin…

    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

  8. #8
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    Default Re: Unable to reset admin password in phpmyadmin…

    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);

 

 

Similar Threads

  1. v150 admin password expired, won't reset, will not send new password to email
    By baltimorestreetmods in forum General Questions
    Replies: 2
    Last Post: 6 Sep 2012, 07:16 PM
  2. v150 HELP.. killed my phpmyadmin when trying to reset password.. now nothing works
    By thecounsil in forum Installing on a Linux/Unix Server
    Replies: 27
    Last Post: 24 Apr 2012, 07:14 PM
  3. Unable to reset the passworst through PhpMyadmin
    By raulmalik in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 28 Dec 2011, 04:37 AM
  4. Unable to reset admin password
    By cyrusli in forum General Questions
    Replies: 3
    Last Post: 20 Nov 2009, 06:18 AM
  5. Resending admin password via phpmyadmin
    By Raichumaximus in forum General Questions
    Replies: 2
    Last Post: 9 Oct 2007, 09:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR