Skip to content

Instantly share code, notes, and snippets.

@8ctopotamus

8ctopotamus/gist:b7474c6e027ae4c6cabb1c15f9fb03aa

Created November 13, 2022 16:04
Show Gist options
  • Save 8ctopotamus/b7474c6e027ae4c6cabb1c15f9fb03aa to your computer and use it in GitHub Desktop.
Save 8ctopotamus/b7474c6e027ae4c6cabb1c15f9fb03aa to your computer and use it in GitHub Desktop.
Download ZIP
Update a WP User's nicename/login through mysql
Raw
gistfile1.txt
UPDATE wp_users SET user_nicename = "new_username", user_login = "new_username" WHERE user_login = "old_username";
SELECT * FROM wp_users WHERE user_login = "new_username";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment