/etc/passwd
/etc/userdomains
/etc/group
/etc/dbowners
/var/cpanel/users/
/var/cpanel/userdata/
/var/cpanel/databases
/var/cpanel/databases/users.db.cache
/var/cpanel/databases/users.db
Check for the domains zone file entries in /var/named and /etc/named.conf. If so remove them .
Once every thing is confirmed to be clean, execute the scripts
/scripts/updateuserdomains
/scripts/rebuildhttpdconf
then restart httpd
Remove MSQL user
First we’ll login to the MySQL server from the command line with the following command:
mysql -u root -p
In this case, I’ve specified the user root with the -u flag, and then used the -p flag so MySQL prompts for a password. Enter your current password to complete the login.
If you need to change your root (or any other) password in the database.
You should now be at a MySQL prompt that looks very similar to this:
mysql>
If you haven’t yet created a MySQL user.
Viewing a full list of MySQL users, including the host they’re associated with, can be done with the following select statement:
SELECT User,Host FROM mysql.user;
To remove a user from MySQL, we again use the DROP command.
It only takes one simple command to delete a user in MySQL, but BEWARE; dropping a user can not be undone! The command is as follows:
DELETE FROM user where User = '
testuser
';
DROP USER 'testuser'@'localhost';
If a user of the name testuser does not exist, then you’ll receive this error:
ERROR 1396 (HY000): Operation DROP USER failed for 'testuser'@'localhost'
Refer to the View a List of MySQL Users section above if you receive the above error, and double check the username and host.