how to reset mysql root password

It happens to the best of us. You get locked out of your MySQL or MariaDB database, and suddenly, everything grinds to a halt. Whether you inherited a server...