Page 1 of 1
Increasing the length of the db user
Posted: Mon Jan 05, 2015 10:07 am
by eagles051387
Hi All,
I am just wondering is it possible to increase the length of 16 characters including the prefix, if not is there a way we could remove the prefix so One can take complete advantage of the full 16 characters?
Re: Increasing the length of the db user
Posted: Wed Jan 07, 2015 5:43 am
by skurudo
eagles051387 wrote:
I am just wondering is it possible to increase the length of 16 characters including the prefix, if not is there a way we could remove the prefix so One can take complete advantage of the full 16 characters?
It's MySQL limitation. Sad, but true.
If it's MySQL's User table, then login as root
Code: Select all
mysql --user=root mysql -pPASSWORD
ALTER TABLE user MODIFY user CHAR(100);
commit;
MySQL manual warns against it:
MySQL user names can be up to 16 characters long. Changing the maximum length is not supported. If you try to change it, for example by changing the length of the User column in the mysql database tables, this will result in unpredictable behavior. (Altering privilege tables is not supported in any case.) Operating system user names might have a different maximum length. For example, Unix user names typically are limited to eight characters.
refer
http://dev.mysql.com/doc/refman/4.1/en/user-names.html
Re: Increasing the length of the db user
Posted: Thu Jan 15, 2015 9:30 am
by eagles051387
Thanks for the information.
Re: Increasing the length of the db user
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