How can the admin change another guy's username?

[yanOnGithub]

Another guy's username is readonly when the admin open the user profile.

[lafriks]

It is not possible currently but this should be added to user administration page then

[yanOnGithub]

Is it sufficient to update user.name and user.lower_name in gitea.db sqlite?

[lafriks]

yes, that should be enaugh

[adelowo]

Duplicate of #1818

[mxmehl]

For future reference, it is also necessary to rename the folder of the user in gitea's ROOT path, otherwise the links on the profile page break.

[yanOnGithub]

gitea's ROOT path

What do you mean by ROOT path? Do you mean the gitea-repositories folder? or the GITEA_HOME folder?

[mxmehl]

What do you mean by ROOT path? Do you mean the gitea-repositories folder? or the GITEA_HOME folder?

The former. In app.ini, it's defined as ROOT inside the [repository] section. This directory contains one folder per user/organisation, and this is the one you'll have to rename.

[aveao]

For further future reference, you'll also want to update user's repositories to point to the right owner_name.

This is what we had to do to move a user (other than also moving the directory):
UPDATE public.user SET name = 'newname', lower_name = 'newname' WHERE name = 'oldname';
UPDATE public.repository SET owner_name='newname' WHERE owner_id=123;