Resolved MariaDB username length up to 80 characters

[B4c4rd1]

Hello,

MariaDB 10.x supports a username with a length of 80 characters and MySQL as of version 5.7.9, 32 characters.

Plesk supports only 16 characters. Can this value be changed in the database? Is there an invisible switch as:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "insert into misc(param,val) values('db_user_length',7)"

Thanks for your Reply!

 

[UFHH01]

Hi B4c4rd1,

these limits are hardcoded and can not be changed, as you may read as well at:

What limits are there in Plesk for username/password length? ( KB - article )​

 

[B4c4rd1]

Thanks for your reply @UFHH01 . I mean the MySQL Username. MariaDB supports usernames up to 80 characters.

You mean:

Plesk user name length 1...20
Plesk user password length 5...160
System user name length 1...16
System user password length 5...255
MySQL aka MariaDB username: 80

This my littletest in PHPMyAdmin:



You can create here the database user:

 

[UFHH01]

Hi B4c4rd1,

due to the fact, that a "system user" is as well a "domain system user", or a "domain ftp user", etc. ... pls. consider to equal YOUR "MySQL aka MariaDB username length" to "System user name length".

 

[B4c4rd1]

Many thanks to the Plesk team for the implementation! Better late than never!