How to fix error " MySQL user exists " While restoring a cPanel account

[mohitht]

Hi All,

Sometimes while restoring a cPanel account their might be causing an error like “Account Creation Status: failed (Sorry, a mysql user with the name already exists”

In order to fix this issue  follow the steps below

First check for entries of that usernames in the following files and if there is any, remove those entries.

/var/cpanel/databases/users.db

/etc/dbowners

After removing the entries , execute the following command.

userdel -f username


The above commands will also fix the error, “Account Creation Status: failed Sorry, a user with the name already exists”


Thanks