<\/figure><\/div>\n\n\n\nGo to the wp_users<\/em> table in your database.<\/p>\n\n\n\nIf your database uses custom prefixes, then you might not see wp_users<\/em>. Whatever the prefix, you need the row that ends with _users<\/em>.<\/p>\n\n\n\nYou should see one or more users in the database.<\/p>\n\n\n\n
Click \"Copy\" on one of the rows.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nYou'll be taken to a new screen which has all the details of the user you copied already filled out.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nChange the login details to the new user<\/h2>\n\n\n\n Change the following fields to what will become the login for your new user:<\/p>\n\n\n\n
user_login<\/li> user_nicename<\/li> user_email<\/li> display_name<\/li><\/ul>\n\n\n\nYou can set user_login<\/em>, user_nicename<\/em> and display_name<\/em> to be the same thing.<\/p>\n\n\n\nIn this example, I'll put \"tom\" into those three fields and Tom's email into the user_email<\/em> field.<\/p>\n\n\n\nDon't put anything into the ID field. phpMyAdmin will set the ID automatically when you save the row.<\/p>\n\n\n\n
Add your password in plain text to the user_pass<\/em> field. Don't use an apostrophe in the password. You can use spaces, alphanumeric characters and some special characters. You don't need to get too crazy with the password if you're going to change it in the backend later.<\/p>\n\n\n\nIn the function dropdown next to user_pass<\/em>, choose \"MD5\". This will convert the password to a hash, which is how WordPress stores passwords in the database.<\/p>\n\n\n\nClick \"Go\" to save the row and return to the wp_users<\/em> screen.<\/p>\n\n\n\n <\/figure><\/div>\n\n\n\nThis will create the new user.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nConnect the admin ID to user capabilities and level<\/h2>\n\n\n\n Before you move on to the next step, take a note of the ID of the user you just created.<\/p>\n\n\n\n
In this example, the ID is \"2\", but it might be different for you.<\/p>\n\n\n\n
The ID will be created automatically by incrementing from the last created row, but don't assume that if the only other ID is 1, that the new ID will be 2. If it is higher, it's because at some point there was another user which had the ID of 2 or higher.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nGo to the wp_usermeta<\/em> table and look for an admin user.<\/p>\n\n\n\nClick \"Copy\" on the wp_capabilities<\/em> row.<\/p>\n\n\n\n <\/figure><\/div>\n\n\n\nA new screen will open with the admin's details filled out.<\/p>\n\n\n\n
Just change the user_id<\/em> to your new admin user. In this example, the new admin's ID is 2.<\/p>\n\n\n\nIf you inserted a new row, rather than copying a current admin, you need these values:<\/p>\n\n\n\n
user_id<\/em>: 2 (or whatever the ID of the admin you created is)<\/li>meta_key<\/em>: wp_capabilities<\/li>meta_value<\/em>: a:1:{s:13:\"administrator\";b:1;}<\/li><\/ul>\n\n\n\nDon't insert anything at umeta_id<\/em>. phpMyAdmin will take care of that.<\/p>\n\n\n\nClick \"Go\" to save the row and return to the previous screen.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nCopy the wp_user_level<\/em> row, the same way you did with the wp_capabilities<\/em> row.<\/p>\n\n\n\nYou'll be taken to a new screen.<\/p>\n\n\n\n
Change the user_id<\/em> to the ID of the admin you created. In this example, the ID is 2.<\/p>\n\n\n\nIf you inserted a new row, rather than copying a current admin, the information you need to enter is:<\/p>\n\n\n\n
user_id<\/em>: 2 (or whatever the admin's ID you created is)<\/li>meta_key<\/em>: wp_user_level<\/li>meta_value<\/em>: 10<\/li><\/ul>\n\n\n\nDon't add anything to umeta_id<\/em> as phpMyAdmin will automatically assign that.<\/p>\n\n\n\nClick \"Go\" to save the row.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nThat's all you need to do to create a new WordPress admin user through phpMyAdmin.<\/p>\n\n\n\n
You can go ahead and login to the WordPress dashboard using the credentials you created.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes a client will give you cPanel access to a WordPress website, but not the login details for an admin. Other times, you might find yourself locked out of WordPress, or the site got hacked and the password changed. Whatever the reason, you might need to manually create a new admin user through the database.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\n
How To Create A New WordPress Admin User In phpMyAdmin<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n