Change initial account username in database?

  • Resolved tbronson

    (@tbronson)


    13 years, 11 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)
  • Chris_K

    (@handysolo)

    13 years, 11 months ago

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

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    13 years, 11 months ago

    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.

    Chris_K

    (@handysolo)

    13 years, 11 months ago

    Apologies. I misread the question.

    Thread Starter tbronson

    (@tbronson)

    13 years, 9 months ago

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

    Thanks!

    Rab

    (@rab-rrdev)

    13 years, 9 months ago

    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.