Awhile back, I wrote up some instructions for doing a basic install of MySQL on Windows, including the steps to secure it. Now that I’m working on another MySQL book, I decided to start putting together some videos to go with it and I’ve created a couple on MySQL / MariaDB installation.
These videos include both the basic manual and the MSI wizard installs. While MariaDB is a drop-in replacement for MySQL and similar in most respects, there are some minor differences that have crept in, including during installation. For that reason, it’s good to be familiar with both.
The options available during the MSI installs are also pretty different. MySQL still uses MySQL Workbench for it’s GUI and while Workbench will work with MariaDB, it tends to complain about it. HeidiSQL is included as an option in the MariaDB install.
All the options are, of course, available on their respective download pages.
MySQL: https://dev.mysql.com/downloads/mysql/
MariaDB: https://downloads.mariadb.org/