We got hacked yesterday due to a compromise in the theme we were using. Once we had our hosting service restore access to our CPANEL, we were able to remove the offending user (the hacker created their own user for Word Press).
However, it seems in this act they had deleted ours as well so we had created a new user by using phpMyAdmin. The user was created, however whenever we logged in it would say
"You do not have sufficient permissions to access this page."
I could not find a privileges page in our phpMyAdmin (it says "no privileges" despite us being the root/admin to it).
How can we regain access to our site? Is there a way to give ourselves the allowance to view our dashboard?