Account Creation Status: failed (Sorry, a mysql user with th

Post Reply
a24uall
Site Admin
Posts: 166
Joined: Sun Jul 01, 2012 9:07 am

Account Creation Status: failed (Sorry, a mysql user with th

Post by a24uall »

This mainly happens if you terminated a cpanel account and somehow the MySQL user was not deleted properly.

Solution : Try deleting the mentioned user.

Delete the user :
mysql
mysql > use mysql;
mysql > drop user testusr7@localhost;
If it wont delete try
mysql> delete from mysql.user where user='testusr7';
You can also check this using
mysql > use mysql;
mysql> select User, Host from user where User like '%testusr7%';
Now try restoring/recreating whatever you were trying to do and see if you still receive the error.

If yes do
grep testusr7 /var/cpanel/databases/users.db
grep testusr7 /etc/dbowners
If the user exist in the above files, delete that and try again.

It fixed for me!!!
Arun
WebhostingDevelopment.com
a24uall
Site Admin
Posts: 166
Joined: Sun Jul 01, 2012 9:07 am

Re: Account Creation Status: failed (Sorry, a mysql user wit

Post by a24uall »

Also try checking the username in
/var/cpanel/databases/dbindex.db.cache
/var/cpanel/databases/users.db
/var/cpanel/databases/users.db.cache
/var/cpanel/databases/dbindex.db
Arun
WebhostingDevelopment.com
Post Reply

Return to “ERRORS”