Knowledge Base

Unable to create Mysql database in Plesk: Database user name is invalid. Only latin letters are allowed in the database user name

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.