How to add a new administrator to your WordPress from the database
This video will show you how to add a new administrator to your WordPress using your database. This is particularly handy if your website is ever hacked and your user account is deleted, or if a client gives you access to their web hosting but can’t either remember or doesn’t have their WordPress administrator login.
This video moves pretty quick but don’t forget that you can always pause at various screens when you need the details. When you’re creating the user you need to add email login and password and don’t forget to make the password MD5 format from the drop-down.
Then in the user meta table, there are two rows to add. Then you should be a login to your WordPress with the new user account … Check the video below