Rename superuser name


#1

Rename superuser name?

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

Tahnks


(Matthieu Aubry) #2

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)


#3

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


(Matthieu Aubry) #4

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


#5

That did it, thank you very much!