How to change a username?

Answer originally posted on another question which was more “why we can’t” instead of “how”: https://web.archive.org/web/20210408084000/https://wordpress.stackexchange.com/questions/135304/why-cant-i-update-username-through-wordpress-api/386265

Here is the solution I used to change the username properly (based on https://www.wpbeginner.com/wp-tutorials/how-to-change-your-wordpress-username/ which had missing information):

I was able to change the username simply with SQL using update wp_users set user_login = "old_username", user_nicename = "new_username" where id = user_id; (replace old_username, new_username and user_id with your values).

The old username will still be present in some other tables, for example “old_username changed the comment status to approved” in table wp_commentmeta, column meta_value but it looks like it is not necessary to change it.

In addition I did a permalink redirect in Apache with the rule RedirectPermanent /blog/author/old_username /blog/author/new_username to avoid 404 Not Found errors since the link was indexed by search engines.

I also updated my username for the comments I left on my website, using the comments menu in WordPress (not necessary but just to be consistent and avoid confusion for visitors).

There is another configuration to change if you are using a multisite installation, to stay a Network Admin.
This can be done by changing the line with the column meta_key that has the value site_admins (Add WordPress MU Network Admin via Database), for example with an SQL statement like update wp_sitemeta set meta_value = "a:1:{i:0;s:4:\"bapt\";}" where meta_id = 8; (note that the value 4 should match the length of the username, bapt in this case and the ID 8 can be different in your case). Note: with wp-cli search-replace function, you don’t need to worry about the length: Why can’t I update username through WordPress API?

Also if your website is open to username registration, for example with BuddyPress, I think another user will be able to create a username that is an old one of someone else and you could have issues with the Apache redirect (you would need to disable the redirect or forbid registration of old usernames in this case).

Related Posts:

  1. Hebrew username
  2. How to translate “ERROR: Invalid username. Lost your password?”
  3. Change default ordering of display name
  4. use of nickname and nicename?
  5. How to retrieve lost username/ email log- in ?
  6. How can I allow Arabic usernames in WordPress
  7. Reset admin and password
  8. How to recover lost username?
  9. How to add @ symbol to user url
  10. How to assign a UserName value at creation
  11. How can hackers access WP usernames? [duplicate]
  12. Disable author admin just use name.
  13. I want to use my username to post blog posts, is this advisable?
  14. Alphanumeric usernames and error message for it
  15. How do I display logged-in username IF logged-in?
  16. Where can I find documentation on what characters are allowed in user names and why?
  17. Filter username field on registration for profanity and unwanted words
  18. Displaying Logged-In User Name in WordPress Menu
  19. Problem with Hebrew characters in username
  20. Allowing an email as the username?
  21. Why can’t I update username through WordPress API?
  22. How can i force Display names to be the same as Usernames?
  23. Change user’s display name programmatically
  24. Email as Username in registration
  25. WordPress User Name Limitations
  26. Pre-populate Username Field
  27. Menu Link Redirect Based on Username or User ID
  28. How to override WordPress registration and insert an auto-generated username?
  29. add the user name to menu when user is logged in [closed]
  30. One time username change from frontend?
  31. Function to change a label (Username) in a core WordPress File (wp-includes/general-template.php)
  32. Register email as username
  33. How do I display the commentor’s first name and last name in the comments?
  34. Update user_login to change username
  35. Username field is not shown in Woocommerce’s registration contact form
  36. White spaces in username give 404 on author page
  37. auto assign sequence base username while registration
  38. How to set a minimum length for username in Woocommerce? [closed]
  39. Showing the user’s username in registration email or activation page with BuddyPress [closed]
  40. Change Username?
  41. How to check username availability with ajax at registration
  42. Change username before login
  43. How to display user nickname (not display name) in PHP template?
  44. How to allow wordpress to create username with symbols like +
  45. Display first name of logged in user?
  46. Private page protected with username and password
  47. Is it possible to incorporate username in a login redirect?
  48. How do I display user name, role and site name using HTML tags inside a dashboard notification?
  49. How can i change the name order in the admin?
  50. how to remotely check a username / password from within a plugin
  51. How do I display “Hello username” if logged-in on the homepage
  52. Restrict certain character combinations in username during registration
  53. How can I display nickname instead username in links
  54. Unique User for all visitor, but possibility to comment with unique name
  55. php function to display commenter username or login
  56. Renaming admin user on multisite install by MySQL
  57. Calling User Nickname
  58. allow only lowercase user registrations
  59. Can anything go wrong if I let users change their usernames?
  60. Lock out all WordPress Administrators except two specific users
  61. php if username is role
  62. Is it possible to rebuild the website while not accesseing the original database?
  63. Add Username to URL for redirect
  64. Default Display Name As Username
  65. How to let the users edit their user names?
  66. Invalidate username if it contains @ symbol
  67. Display first name instead of username
  68. buddypress remove username from autocomplete
  69. Change user nicename without sanitize
  70. How to show my wordpress admin username & password?
  71. Redirect user to specific link after login
  72. WordPress not logged in locally with correct username and password
  73. How can I apply custom sanitization to new usernames?
  74. track all external links on blog via username
  75. How to change the User name and Password of admin account
  76. Custom User Registration script only allowing usernames with 16 characters
  77. php return username of currently viewed author profile
  78. Username was changed to “admin”
  79. Why do people use “admin” username by default? [closed]
  80. Redirect users with “.” (dot) in their username and replace with “-” (dash) to correct profile
  81. Display a custom name when the user has no name settle in his account
  82. Make WordPress User Name be the Company Name when Registering (not the default ‘first name’ last name’ email address’)
  83. How to add logged in username after WordPress URL?
  84. Show username only if logged in in a else no directly name
  85. Redirect user to a custom url after logged in
  86. How to get all multi-select user meta values and add them to an array?
  87. Allowing Non-Latin Characters In WordPress Registration
  88. How to auto-generate random numbers in username?
  89. How to gets users EMAIL by their USERNAME
  90. I have restricted the username to numerical format but not able to integrate the same with PeepSo plugin
  91. User login without username, only password
  92. What WordPress file is saving new users to database
  93. Username from e-mail
  94. Fetch data from a WP page with same name as current username
  95. Cannot login with correct username and password anymore
  96. Limit username to specific characters (A-Z and 0-9)
  97. Username character requirements
  98. How To Change Username Slug
  99. How to use same username account for multiple users?
  100. wp_user_query with meta_value_num for leaderboard

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)