{"id":19069,"date":"2021-01-20T17:00:05","date_gmt":"2021-01-20T16:00:05","guid":{"rendered":"https:\/\/qodeinteractive.com\/magazine\/?p=19069"},"modified":"2021-01-19T11:16:40","modified_gmt":"2021-01-19T10:16:40","slug":"phpmyadmin-add-user","status":"publish","type":"post","link":"https:\/\/qodeinteractive.com\/magazine\/phpmyadmin-add-user\/","title":{"rendered":"How to Add a User to the WordPress Database via phpMyAdmin"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]Losing access to a website\u2019s dashboard has happened to every WordPress user that takes part in website creation at least once. Most often, it\u2019s a matter of a forgotten password. In that case, you can easily recover the password<\/a> using the recovery email or by changing it directly in the database.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]However, in other, less frequent cases, regaining access to the dashboard can be quite a problem. Admin accounts are impacted the most by this, as they have the most privileges. These other reasons for losing access to the dashboard include accidentally deleting the user account or your website getting hacked, which can result in some accounts, including your only admin account, being deleted.
\n[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]It\u2019s also possible that you only had one admin account tied to your previous webmaster, whose departure left you unable to log in to your admin dashboard or any of your non-admin accounts.
\n[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Knowing how to add a WordPress user via phpMyAdmin can come in handy in those situations. This is particularly relevant for adding admin accounts and as such, they will be the main focus of this article. However, we will also show you how to add accounts with default (non-admin) user roles should you need to do so outside of your dashboard.
\n[\/vc_column_text][vc_empty_space height=”80px”][vc_widget_sidebar sidebar_id=”new-top-picks-banner”][vc_empty_space height=”81px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

How to add a user to the WordPress database via phpMyAdmin<\/h2>\n

[\/vc_column_text][vc_column_text]Since we already touched on why it would be useful to know other means of regaining access to your dashboard, let\u2019s now delve into how to do it. To be able to apply our suggested methods, you will need to have access to your web hosting control panel. We will be using cPanel in our examples.
\n[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]In the following section, we will show you how to add a WordPress user via phpMyAdmin and how to assign them admin privileges. We will also discuss how the process will differ if you wanted to assign other, non-admin privileges. Since this guide requires you to edit your database directly, making a backup of it<\/a> beforehand is highly advisable.[\/vc_column_text][vc_empty_space height=”72px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

<\/a>How to add an admin user to the WordPress database via phpMyAdmin<\/h3>\n

[\/vc_column_text][vc_column_text]First, connect to cPanel<\/strong> using your cPanel credentials and click on the phpMyAdmin<\/em> option<\/strong>, located in the Databases<\/em> section near the top of your screen.[\/vc_column_text][vc_empty_space height=”50px”]

\n
\n \"Databases <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Having clicked it, phpMyAdmin will open in a separate tab. Find your database<\/strong> in the menu on the left and click on it to open, then find the wp_users table<\/strong> and click on it<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Database <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Before we go any further, we should quickly address two issues you might run into while performing the steps outlined above.
\n[\/vc_column_text][vc_empty_space height=”22px”]