Notes

How to add a WordPress Admin user via PhpMyAdmin

Edit on GitHub

Databases

Why?

Add support user for all hosting accounts that have wordpress installed, with one command via phpmyadmin and whm access.

1INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('9191919', 'username', MD5('password'), 'Name', 'test@yourdomain.com', 'http://hostmarkaz.com/', '2015-02-11 00:00:00', '', '0', 'Your Name');
2
3INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '9191919', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
4
5INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '9191919', 'wp_user_level', '10');

Fields to change

  • Database = databasename
  • ID = 9191919
  • user_login = username
  • user_pass = password
  • user_nicename = Name
  • user_email = test@yourdomain.com
  • user_url = http://hostmarkaz.com
  • user_activation_key =
  • user_status = 0
  • display_name = Your Name

Notes:

  • Keep the ID number really high to avoid conflicts and errors. Some sites really have a lot of users because of affiliate or membership plugins.

Source

Related