Rename superuser name

Rename superuser name?

I know it states it cannot be changed via interface, but would renaming it in database via phpmyadmin work?

Tahnks

It would work but make sure to also rename other tables where the username may appear in _report and _access etc.

PS: to be safe, make a DB backup before attempting as I haven’t tested it yet (but i’ll be here to assist in case of issues)

Doesn’t work. Found it in 4 tables, and got Error: Wrong Username and password combination. after renaming it. Tables:

_option - 3 matches
_segment - 6 matches
_user - 1 match
_user_dashboard - 1 match

Thanks

After changing username you must also reset password as explained in How do I change the Super User's password when password recovery emails are not sent? - Analytics Platform - Matomo

That did it, thank you very much!