Skip to main content

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

Mary Wior
  • Updated

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:

  1. Access the server's command line as the 'root' user via the "Terminal" interface in WHM or SSH.
  2. Access MySQL. 
    mysql
  3. Access the "mysql" database. 
    use mysql;
  4. 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.

Related articles