Change initial account username in database?

  • Resolved tbronson

    (@tbronson)


    14 years, 6 months ago

    I created a WP blog with username “admin” and now I want to change username “admin” to something else, without losing the posts attached to it. Can I change the name directly in the database (e.g. via phpMyAdmin)? Will that break anything?

Viewing 5 replies - 1 through 5 (of 5 total)

  • Be sure to update your wp-config.php accordingly and you should be OK.

    Moderator James Huff

    (@macmanx)

    If you mean changing the “admin” user name, you won’t need to edit the wp-config.php file. Just backup your database, then access it via phpMyAdmin and go to the wp_users table. Click the edit button (the pencil icon) next to your user and change what is entered into the user_login field.

    Apologies. I misread the question.

    Thread Starter tbronson

    (@tbronson)

    I changed the user_login field in the wp_users table, using phpMyAdmin. Worked fine!

    Thanks!

    You can also create another user, then delete the Admin user. It asks what to do with the Admin account’s posts. Here you can select to move them to the new user you created.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Change initial account username in database?’ is closed to new replies.