1. Home
  2. WordPress Tips

WordPress Tips

[How to] Add User to WordPress using SQL INSERT

WPAssist / WordPress Hacks - April 8, 2020

If you want to add a new user to WordPress database using MySQL using phpMyAdmin or a similar tool, you can use the following snippet: INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘admin’, ‘$P$Bg/Ol6U.M07OGU7sKEZvIyl.mxuQQw.’, ‘admin’, ‘[email protected]’, ”, ‘2018-12-21 16:34:15’, […]