How to set MySQL/MariaDB root password

This quick and straight forward video demonstrates how to set a root password for MySQL/MariaDB. It also show how to install Apache and MySQL as Windows service. To set MySQL/MariaDB root password open the command prompt and type in the following command:
set password for ‘root’@’localhost’ =password(‘YOUR_PASSWORD’);

If you have PHPMyAdmin, you can then let it know that you have made the changes to your root password by editing the config.inc.php file found within the phpmyadmin directory.