How To Reset Your MySQL or MariaDB Root Password

Reset your MySQL or MariaDB root password when you no longer have the old one. If you have server access and a sudo user, you can recover root using skip-grant-tables or the safer --init-file method. Covers MySQL 5.7+, MySQL 8+, MariaDB 10.1+, and MariaDB 10.4+.