This tutorial will help you that how you can reset root password (if you’ve forgotten the password) of MySQL
Restore MySQL Database Without SQL Dump
This article will help you to know about how you can restore your database when you don’t have SQL dump file.