Author Topic: Can't delete MySQL user after "cPanel Account Restore"  (Read 345 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Can't delete MySQL user after "cPanel Account Restore"
« 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?

Offline
*****
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #1 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.

Offline
**
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #2 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

Offline
*****
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #3 on: April 12, 2025, 11:45:42 AM »
And you tried from phpMyAdmin (logged in as root)?

Offline
**
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #4 on: April 14, 2025, 04:59:09 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

 

Offline
*****
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #5 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.

Offline
**
Re: Can't delete MySQL user after "cPanel Account Restore"
« Reply #6 on: April 14, 2025, 11:29:27 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