Skip to content

Instantly share code, notes, and snippets.

@bookwyrm

bookwyrm/change-admin-user-id.sql

Created June 24, 2015 13:33
Show Gist options
  • Save bookwyrm/3d80f8935c2d0a254348 to your computer and use it in GitHub Desktop.
Save bookwyrm/3d80f8935c2d0a254348 to your computer and use it in GitHub Desktop.
Download ZIP
Walkthrough: Setting up a Secure WordPress Site with Git – Part 2
Raw
change-admin-user-id.sql
UPDATE wp_EkUMs54Z_users SET ID = 10 WHERE ID = 1; -- update user id
UPDATE wp_EkUMs54Z_usermeta SET user_id = 10 WHERE user_id = 1; -- retain permissions
ALTER TABLE wp_EkUMs54Z_users AUTO_INCREMENT = 11; -- make sure auto increment stays correct
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment