Increasing the length of the db user

[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?

[skurudo]

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;

THE ABOVE IS NOT RECOMMENDED

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

[eagles051387]

Thanks for the information.

[skurudo]

Added idea on bugtracker:
https://bugs.vestacp.com/issues/258

Please vote for this feature.

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