Page 1 of 1
Username length and database creation
Posted: Wed Oct 01, 2014 7:47 am
by sau
When creating a user - no prompt about length of username. As a result - if the user name 15 or more characters - this user can't create a database.
Re: Username length and database creation
Posted: Thu Jan 22, 2015 10:16 am
by kusspaprika.com
Same problem here.
I read that MYSQL has hard coded 16char for Username.
So it seams the Username of VCP-User has to be limited + the MYSQL-User must limited to max length.
Will this solved next release?
Is a workaround out there (without new registration of the user)
@The VCP Team: You are doing a great job!
... I found more information on this.
viewtopic.php?f=14&t=6740
Re: Username length and database creation
Posted: Thu Jan 22, 2015 10:30 am
by sau
It will be a nice fix of this issue to make an option for use or no the prefix in database names.
Re: Username length and database creation
Posted: Thu Jan 22, 2015 5:54 pm
by skurudo
kusspaprika wrote:So it seams the Username of VCP-User has to be limited + the MYSQL-User must limited to max length.Will this solved next release?
sau wrote:It will be a nice fix of this issue to make an option for use or no the prefix in database names.
But how? It's
MySQL limitations, not VestaCP
It was light hope, MariaDB will support long username, I was wrong.
Long usernames supports, but by dirty hack and patch. Works that not stable.
Nice to see link on my answer. ))
Re: Username length and database creation
Posted: Fri Feb 20, 2015 2:02 pm
by kusspaprika.com
I think another way is to shortening the username if its used for MySQL users prefix
+ limit the MySQL usernames so its not more than 15 characters.
sau wrote:It will be a nice fix of this issue to make an option for use or no the prefix in database names.
Thinking...
It would be a nice solution if I can set a MySQL prefix in user-profile, the standard would be a shorten username.
Shortening username to 7 characters, probably like this:
Code: Select all
$username = "brennholzhandel-boxberg.de";
if (strlen($username) >= 7) {
echo substr($username, 0, 4). "-" . substr($username, -2);
}
else {
echo $username;
}
--> $username = "bren-de";
+ MySQL-Username-field-limit to 8 characters, could do it.
What do you think?
Hope we can find a good solution for all.
Regards
Re: Username length and database creation
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: Username length and database creation
Posted: Fri Jun 10, 2016 12:48 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