We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Increasing the length of the db user
-
- Posts: 40
- Joined: Mon Dec 22, 2014 1:29 pm
Increasing the length of the db user
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?
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
It's MySQL limitation. Sad, but true.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?
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:
refer http://dev.mysql.com/doc/refman/4.1/en/user-names.htmlMySQL 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.
-
- Posts: 40
- Joined: Mon Dec 22, 2014 1:29 pm
Re: Increasing the length of the db user
Thanks for the information.
Re: Increasing the length of the db user
Added idea on bugtracker:
https://bugs.vestacp.com/issues/258
Please vote for this feature.
Discussion topic:
viewtopic.php?f=14&t=11522
https://bugs.vestacp.com/issues/258
Please vote for this feature.
Discussion topic:
viewtopic.php?f=14&t=11522