Changing MySQL DB User Prefix Length

[Amin Taheri]

MySQL DB User Prefix of "<client name>_" is by default truncating the <client name> to 5 characters. In order to get arround it by inserting a new value into misc table.

This will change it to 10 characters.

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "replace into misc values('db_user_length',10)"

Since MySQL limits usernames to 16 characters, having 10 characters for the prefix and 1 for the seperator leaves 5 characters for the username.

You may want to change the 10 to something else depending on your user base.

 

[Tamás Márton]

Thank You, that's what I was looking for. However I'm more comfortable with the following plesk command (probably this option didn't exist back in 2008).

plesk bin server_pref -u -db-user-length 10

More about setting server_pref:
server_pref: Interface and System Preferences