Page 1 of 1

renaming user to overcome database length restriction

Posted: Fri May 15, 2015 11:35 am
by peterb
I searched for "rename user" but could not see any.

I have an issue where I have created a user with a longish name
17characterusername

all is fine except I can't add any database name, not even _1 as I presume it is too long :-(

How can I edit the user name?
Where is it stored?

Many thanks
Peter

Re: renaming user to overcome database length restriction

Posted: Sun May 17, 2015 10:46 am
by skurudo
the database user should be not longer than 16 characters (together with the prefix of user)

but if you want it so badly, there is not tested officially fix - viewtopic.php?f=14&t=4927#p14320

Re: renaming user to overcome database length restriction

Posted: Sun May 17, 2015 12:45 pm
by peterb
@skurudo THANK YOU so much !

For speed I rebuilt the account, but it would be NICE if the limit was KNOWN at the point of account creation.

IMHO domain names are getting longer these days (due to competition) and it's natural to use a longer account name of it.

Re: renaming user to overcome database length restriction

Posted: Sun May 17, 2015 2:08 pm
by skurudo
peterb wrote: For speed I rebuilt the account, but it would be NICE if the limit was KNOWN at the point of account creation.
IMHO domain names are getting longer these days (due to competition) and it's natural to use a longer account name of it.
You need to know, it's mysql limitation and not recommended to use names longer.

Re: renaming user to overcome database length restriction

Posted: Fri Jun 10, 2016 12:49 pm
by skurudo
Added idea on bugtracker:
https://bugs.vestacp.com/issues/258

Please vote for this feature.

Discussion topic:
viewtopic.php?f=14&t=11522