Last active
November 2, 2020 16:35
-
-
Save atxiii/00915068d0122e07e7f72b904923b8b4 to your computer and use it in GitHub Desktop.
Update Manually WP_USER AND WP_USERMETA
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#WP_USERS | |
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 | |
(4,'aaa','$P$BmPs7v0824pjqq1bY7WZsKtl0qjw0x0','aa','daphne@aa.com','''','2019-07-01 03:45:13','''',0,'The aa') # yourdata | |
ON DUPLICATE KEY UPDATE | |
user_pass=VALUES(user_pass), | |
user_nicename=VALUES(user_nicename), | |
user_nicename=VALUES(user_nicename), | |
user_email=VALUES(user_email), | |
user_url=VALUES(user_url), | |
user_registered=VALUES(user_registered), | |
user_activation_key=VALUES(user_activation_key), | |
user_status=VALUES(user_status), | |
display_name=VALUES(display_name); | |
#WP_USERMETA umeta_id user_id meta_key meta_value | |
INSERT INTO `wp_usermeta`(umeta_id,user_id,meta_key,meta_value) VALUES | |
(158,4,_um_last_login,1575947606), #your data | |
ON DUPLICATE KEY UPDATE | |
meta_value=VALUES(meta_value) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment