Corrupt Database, Can’t Login

I am using MAMP to host my wordpress install locally.

I had my computer crash and overheat, and lost the ability to connect to SQL servers. After much work and trying various things I was able to get SQL servers back online and able to connect to the local host page again.

The problem is I cannot login to my wordpress site. I can view the website itself, but I cannot get into the WP admin page. It just tells me the user or password is wrong. I have gone into the wp config file and allowed for repair, and went through the database repair section. It could not repair the User table and a few others. I assume the user table being corrupted is why I cannot login.

My questions are the following. One, is there any way to either repair this table and the others likewise, or if not, is there a way to manually create one, enter some relevant information, and have it work again?

If not, what can I do to start a totally fresh install of WP, a new database, but incorporate the work I have already done? I have not deleted or uninstalled anything, so my WP folder still contains my theme and information etc. Is there an easy way to setup a new WP install, create my login etc, create the new databases, and import in the work I’ve already done? Or do I need to start at square one and basically do everything all over?

I am an idiot and don’t have backups. I thought MAMP was creating them as I went along. If it was I can’t find them (I don’t think it has been). I have one backup made, however it’s the database in its current state, so corrupted tables and all.