Cannot create or restore account: 'The system could not create the user "username" because it conflicts with an unmanaged MySQL database user.'

Symptoms

Attempting to create or restore an account results in an error similar to the following.

CONFIG_TEXT: Failed to create the account: (XID xxxxxx) The system could not create the user "username" because it conflicts with an unmanaged MySQL database user. at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1380.

Cause

This issue is caused by an existing MySQL database or MySQL user that starts with or is identical to the username being restored.

Resolution

You can find the MySQL user that is conflicting with the following procedure:

1. Log in to the server via SSH or WHM's Terminal as the root user

2. Access MySQL:

   # mysql

3. Access the "mysql" database.

   MYSQL_LIN: use mysql;

4. Run the following queries to locate the user:

   MYSQL_LIN: select User, Host from user where User like "username%";

   MYSQL_LIN: select Host, Db, User from db where Db like "username%";

   Note: "username" must be replaced by the cPanel account's username in the above-provided queries. The '%' symbol is a wildcard that will allow the query to locate similar usernames.

Once you know what needs to be removed, your systems administrator or database administrator can determine if the databases and users are needed, and how best to safely remove or rename the databases and database users so that no further conflict exists.