If you experience an issue in which your administrator account is blocked from accessing the WordPress dashboard, one way to resolve the problem is to create a new administrator account. As you are unable to do this from the dashboard, the alternative is to manually create the account in your WordPress database.

Log in to the HostPapa Dashboard and click My cPanel from the top navigation menu. Select phpMyAdmin from the Databases section of the cPanel menu.

Select your WordPress database from the list presented in the left sidebar.

In the right pane, click the SQL button.

Enter the following code in the box labelled Run SQL query/queries on database. This code creates a new administrator account with the following credentials:

  • User name: admin999
  • Password: password999

Change these credentials in the code to your own selection.

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, 
 VALUES ('admin999', MD5('password999'), 'firstname lastname', '[email protected]', '0');
 INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
 VALUES (NULL, (Select max(id) FROM wp_users), 
 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
 INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
 VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');

Click the Go button to run the query.

Now head to the WordPress administration dashboard and try to log in with the newly created credentials.

By Virlif