Can't delete MySQL user after "cPanel Account Restore"

[daviddietz]

I recently switched from cPanel to CWP. After I backed up my cPanel account and imported it into CWP, everything functioned, but a weird thing happened.

CWP created MySQL users from the cPanel backup that can't be deleted. When I try, I get "Error
Invalid System User". Is there a way to resolve this?

[overseer]

The MySQL manager functions can be buggy. Try logging into phpMyAdmin and look at the DB there. You should have full control as the root user to make any adjustments or deletions you need.

[anandmys]

Yes. This is an issue. I have all old users linked to my previous server which cant be deleted

[overseer]

And you tried from phpMyAdmin (logged in as root)?

[anandmys]

And you tried from phpMyAdmin (logged in as root)?

No. Talking about deleting users from database in admin as well as user panels

I imported accounts from cpanel

Now under Admin panel - MySqL Manager - Users I see 2 set of users

User (Localhost)
User (Old Server) - Delete - Error Invalid system user

[overseer]

I've been down that road back when I migrated from cPanel to CWP. I cleaned up the users in PMA, logged in as root.

[anandmys]

I've been down that road back when I migrated from cPanel to CWP. I cleaned up the users in PMA, logged in as root.

Got it. Thank you