'Unable to recover MySQL Database

So I was trying to get my web server setup on my pi by installing mariaDB and phpmyadmin. While doing so, I was going through and dropping tables, and found mysql. I accidently dropped it and lot 21 important files, and I can't seem to figure out how to recover this loss. Due to this, I'm unable to create any new users thanks to an error I created - 1064. Which puts me in a stall.

I've exhausted everything from uninstall to reinstall and nothing seems to give. Googling the issue hasn't been much of a resolve too.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source