Skip to main content

Posts

Showing posts with the label wordpress

How to Add an Admin User to the WordPress Database via MySQL

First, you need to login to phpMyAdmin and locate your WordPress database. (Below is a screenshot of a Hosting cPanel) Once you are in, we will be making changes to the wp_users and wp_usermeta tables. Lets go ahead and click on  wp_users  table. We need to insert our new admin user's information, so click on the Insert tab like it shows in the image above. In the insert form, add the following: ID  – pick a number (in our example, we will use the number 4). user_login  – insert the username you want to use to access the WordPress Dashboard. user_pass  – add a password for this username. Make sure to select MD5 in the functions menu (Refer to the screenshot below). user_nicename  – put a nickname or something else that you would like to refer yourself as. user_email  – add the email you want to associate with this account. user_url  – this would be the url to your website. user_registered  – select the date/time for when this user is registered. user_status  – set this to 0. displa...