When trying to restore an account from a backup file from WHM, do you face this error ?
Account Restore Failed: “Account failure: Failed to create the account: The system could not create the user “xxx” because it conflicts with an unmanaged MySQL database user.”
If you face this error, you might need to verify if there is a user with the above name which might have been the result of an improper termination of the account.
Login to MySQL shell :
# mysql -u root -p ( find MySQL password from /root/.my.cnf )
mysql> use mysql;
mysql> select User, Host from user where User like '%xxx %'; ( Replace xxx with the user which you get when the error hits )
If the user exists, you might get a table like the following depending on the number of such ones :
+———-+——————- +
| User | Host |
+———-+——————- +
| xxxx| xx.xx.xx.xx |
| xxxx| host.hostname.com |
| xxxx| localhost |
+———-+——————-+
Remove all these entries using commands similar to :
mysql> DROP USER 'xxxx'@'xx.xx.xx.xx'; ( the 2nd portion after @ indicates the IP address in this case )
mysql> DROP USER 'xxxx'@'host.hostname.com';
Query OK, 0 rows affected (0.01 sec)
mysql> DROP USER 'xxxx'@'localhost';
Query OK, 0 rows affected (0.00 sec)
Once this is completed, verify there are no more entries :
mysql> select User, Host from user where User like '%xxxx%';
Empty set (0.00 sec)
After this, attempt to restore the account from the backup.
If you still face an issue in restoring, check the file ‘/var/cpanel/databases/users.db‘ and make sure the user is not listed there.
You should be able to restore the account now !
https://k9webops.com/blog/cpanel-account-restore-issue-a-mysql-user-with-the-name-already-exists/