The system could not create the user error

Muhammad Shaqra

Registered
May 26, 2018
1
0
1
Port Said
cPanel Access Level
Root Administrator
hello,

i have a problem when i try to create a new user i get error as below

(XID xsdxxt) The system could not create the user “special” because it conflicts with an unmanaged MySQL database user. at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1196.
even i have removed the user from everywhere and all databases everythings are erased
can anybody tell me what to do to remove it please
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston
Hi @Muhammad Shaqra

Is there a reference to the user in /var/cpanel/databases when you run:

Code:
grep -ir "special" /var/cpanel/databases/
is the user listed when you run the following?
Code:
select * from mysql.user where user like  "special%";