Control Web Panel

WebPanel => MySQL => Topic started by: daviddietz on December 07, 2024, 11:39:18 PM

Title: Can't delete MySQL user after "cPanel Account Restore"
Post by: daviddietz on December 07, 2024, 11:39:18 PM

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?

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: overseer on December 08, 2024, 12:52:36 AM

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.

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: anandmys on April 12, 2025, 11:06:06 AM

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

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: overseer on April 12, 2025, 11:45:42 AM

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

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: anandmys on April 14, 2025, 04:59:09 AM

Quote from: overseer on April 12, 2025, 11:45:42 AM

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

 

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: overseer on April 14, 2025, 10:56:33 AM

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.

Title: Re: Can't delete MySQL user after "cPanel Account Restore"
Post by: anandmys on April 14, 2025, 11:29:27 AM

Quote from: overseer on April 14, 2025, 10:56:33 AM

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