Hello christiechild:
Source: https://www.ads-software.com/support/topic/password-not-recognized-1/
This link shows you how to create a new admin through your database:
Creating a new admin account via MySQL
Make sure you copy all the code exactly.
This assumes that your database table prefix is set to “wp_”.
If you are using something different, then make sure to adjust your code accordingly.
For example, if you are using “wptables_” instead of “wp_”, then the code
“INSERT INTO wp_users“
would be
“INSERT INTO wptables_users“
In the code they provide, you then have to change what is in ‘red’ (…on the actual page I’ve linked is the red colour) in this code:
VALUES (‘newadmin’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’);
=======
newadmin – this you change to the new username (do not use “admin”)
pass123 – this you change to the new password
firstname – this will be what it says, a first name
lastname – this will be what it says, a last name
[email protected] – this will be an email, but do not use the email you already have for the site or for your present admin
=========
Once the database updates, you can go to your wordpress login as normal and use the new admin login information to gain access.
Reset the password for your old account and write down its username and password somewhere.
Log out from the new admin and log in with your now-changed old one to see if it works.
If it does, then you have the choice of either keeping both (a good fail-safe), deleting the new one, or deleting the new one.
