I followed a tutorial at http://www.onextrapixel.com/2010/01/30/13-useful-wordpress-sql-queries-you-wish-you-knew-earlier/ on how to change my WordPress username from admin to my name.

It mostly worked. I initially lost Super Admin and Admin access, but I was able to restore this using my partner’s account.

Everything seems to be fine, until I found out that users could not send me Private Messages in Buddypress. I also noticed that my mention code on my profile is still @admin, and not @bennadler

So it seems the WordPress database was updated, but Buddypress was not. Is there another SQL query I need to run in order to change and fix this? Thanks for your help!

[@sicksight Participant 14 years, 5 months ago]

First: I have not updated to WordPress 3.0 …
I used “root” instead of “admin” and I immediately replaced after the installation all text with “admin” in the database with “root”.

[@djpaul Keymaster 14 years, 5 months ago]

Update the appropiate record in the bp_xprofile_data table (field_id=1, user_id=1).

[@r-a-y Keymaster 14 years, 5 months ago]

By default, BuddyPress uses the user_nicename column in the DB and not the user_login. Make sure your user_nicename is the same as your user_login.

Or you can add the following line to wp-config.php:
define( 'BP_ENABLE_USERNAME_COMPATIBILITY_MODE', true );