Skip to content

Instantly share code, notes, and snippets.

@mrizwan47
Last active July 8, 2021 18:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrizwan47/39938849e09665d04b53a8d7a1ce91b6 to your computer and use it in GitHub Desktop.
Save mrizwan47/39938849e09665d04b53a8d7a1ce91b6 to your computer and use it in GitHub Desktop.
Create new WP user in wpengine through phpmyadmin
INSERT INTO
`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
VALUES (
NULL, 'rizwan', MD5('PASSWORD_HERE'), 'Riz', 'hi@iamrizwan.me', '', NOW(), '', '0', 'Rizwan');
SET @WPUserID = LAST_INSERT_ID();
INSERT INTO
`wp_usermeta`
(`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES
(NULL, @WPUserID, 'nickname', 'Rizwan'),
(NULL, @WPUserID, 'first_name', ''),
(NULL, @WPUserID, 'last_name', ''),
(NULL, @WPUserID, 'description', ''),
(NULL, @WPUserID, 'rich_editing', 'true'),
(NULL, @WPUserID, 'syntax_highlighting', 'true'),
(NULL, @WPUserID, 'comment_shortcuts', 'false'),
(NULL, @WPUserID, 'admin_color', 'fresh'),
(NULL, @WPUserID, 'use_ssl', '0'),
(NULL, @WPUserID, 'show_admin_bar_front', 'true'),
(NULL, @WPUserID, 'locale', ''),
(NULL, @WPUserID, 'wp_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(NULL, @WPUserID, 'wp_user_level', '10'),
(NULL, @WPUserID, 'dismissed_wp_pointers', ''),
(NULL, @WPUserID, 'show_welcome_panel', '1');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment