The system could not create the user error

[Muhammad Shaqra]

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]

Hi @Muhammad Shaqra

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

grep -ir "special" /var/cpanel/databases/

is the user listed when you run the following?

select * from mysql.user where user like  "special%";