sorry, a mysql user with the name already exists
When I tried to restore an account I got the error:
Sorry, a mysql user with the name x already exists.
I know that the user does not exists on the server.
To fix this issue, ran the cPanel script.
/scripts/updateuserdatacache
And the error is gone and I was able to restore the account without any further errors.