Symptoms
When you create or transfer an account, you may receive the following failure:
Account “$USER”: Account Restore Failed:
“Account failure: Failed to create the account: (XID 6abkte)
The name of another account on this server has the same initial 8 characters
as the given username ($USER).
Each username’s first 8 characters must be unique. at
/usr/local/cpanel/Whostmgr/Accounts/Create.pm line 623.”
Description
If you are using MySQL or PostgreSQL, the first 8 characters must be unique on the system. However, when using MariaDB this is not a limitation.
Workaround
You will need to upgrade to MariaDB as your database server and configure the following TweakSetting in WHM.
WHM >> Home >> Server Configuration >> Tweak Settings >> SQL
Then, disable the option called:
"Require a username prefix on names of new databases and database users"
After doing this, you should be allowed to create users which share the same first 8 characters.