We're Hiring!

Mattermost, Inc.

Renaming a user account

Hi.

Is there a way to rename a user account? Every few months someone in our company marries and his/her name changes. If I create a new account, all messages are gone. But I cannot find a way to just rename the account. Mattermost is the only software we use where this is not possible.

Regards,
Thomas

1 Like

I do believe that there is, at least from the database command line, if nothing else. Could you provide a bit more information about your setup, such as your operating system, database, and database engine, etc?

Hi.

Ubuntu 18.04.5 LTS
Mattermost-Version: 5.27.0
Datenbankschema-Version: 5.27.0
Datenbank: mysql

Regards
Thomas

normally the users can change their fullname and user name by themselves under general settings in their profiles.Therefore there is no need for the admin to do these changes.
Or did you lock that feature in your installation so that your users cannot do these changes by themselves?

1 Like

I wrote user account, not user name.

Would you be able to further elaborate on which value of the user’s account your looking to change? This is the database schema for the Users table, which contains each user’s profile information, etc.

+--------------------+--------------+------+-----+---------+-------+
| Id                 | varchar(26)  | NO   | PRI | NULL    |       |
| CreateAt           | bigint       | YES  | MUL | NULL    |       |
| UpdateAt           | bigint       | YES  | MUL | NULL    |       |
| DeleteAt           | bigint       | YES  | MUL | NULL    |       |
| Username           | varchar(64)  | YES  | UNI | NULL    |       |
| Password           | varchar(128) | YES  |     | NULL    |       |
| AuthData           | varchar(128) | YES  | UNI | NULL    |       |
| AuthService        | varchar(32)  | YES  |     | NULL    |       |
| Email              | varchar(128) | YES  | UNI | NULL    |       |
| EmailVerified      | tinyint(1)   | YES  |     | NULL    |       |
| Nickname           | varchar(64)  | YES  |     | NULL    |       |
| FirstName          | varchar(64)  | YES  |     | NULL    |       |
| LastName           | varchar(64)  | YES  |     | NULL    |       |
| Position           | varchar(128) | YES  |     | NULL    |       |
| Roles              | text         | YES  |     | NULL    |       |
| AllowMarketing     | tinyint(1)   | YES  |     | NULL    |       |
| Props              | text         | YES  |     | NULL    |       |
| NotifyProps        | text         | YES  |     | NULL    |       |
| LastPasswordUpdate | bigint       | YES  |     | NULL    |       |
| LastPictureUpdate  | bigint       | YES  |     | NULL    |       |
| FailedAttempts     | int          | YES  |     | NULL    |       |
| Locale             | varchar(5)   | YES  |     | NULL    |       |
| Timezone           | text         | YES  |     | NULL    |       |
| MfaActive          | tinyint(1)   | YES  |     | NULL    |       |
| MfaSecret          | varchar(128) | YES  |     | NULL    |       |
+--------------------+--------------+------+-----+---------+-------+
25 rows in set (0.01 sec)

You are right. :slight_smile:
When I looked the last time it was not possible and I never looked again.
OK, problem solved, thanks.

Regards,
Thomas

2 Likes

Sounds good, glad we could get it solved!