ADMIN WEBHOSTING DEVELOPMENT

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!!!

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