Symptoms
Attempting to create or restore an account results in an error similar to the following.
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.
Description
This issue is caused by there being a MySQL database or MySQL user that starts with or is identical to the username being restored.
Workaround
You can find the MySQL user that is conflicting with the following procedure:
- Access the server's command line as the 'root' user via the "Terminal" interface in WHM or SSH.
- Access MySQL.
mysql
- Access the "mysql" database.
use mysql;
- Run the following queries to locate the user
select User, Host from user where User like "username%";
select Host, Db, User from db where Db like "username%";
Please note, 'username' must be replaced by the cPanel account's username. 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.