• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Changing MySQL DB User Prefix Length

Amin Taheri

Golden Pleskian
Plesk Certified Professional
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.
Code:
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.
 
Back
Top