Symptoms
- The following option is enabled in Plesk > Tools & Settings > Database Hosting Preferences:
- Unable to create a database with username longer than 16 characters:
PLESK_ERROR: Error: Database user name is invalid. Only latin letters are allowed in the database user name
Cause
Plesk 17.0-17.8 doesn’t allow to create MySQL database users longer than 16 characters.
Such unclear error is a bug PPPM-10708 that will be fixed in future Plesk updates.
Resolution
Create database with username less than 16 characters or upgrade to Plesk Obsidian. Plesk Obsidian using up to 32 characters in MySQL 5.7 or up to 80 characters in MariaDB 10.0 and higher versions.
Additional information
[BUG] Migration or Site import fails: Unable to add database user: Database user name is invalid