If you ever get yourself locked out of your WordPress site for any reason and can’t get back in here is a way to save the day assuming you still have access to your host and can run commands on MySQL

If you are using phpMyAdmin simply log in, navigate to your site’s database, then click on the SQL tab on the top and run the following command.

Simply change the values on line 2 to the new user’s data you want to create and run the command. It’s that easy, your new admin user will be ready to go in just one click!