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/
Coming in 2020 - "Understanding MySQL and MariaDB"
Download a FREE sample chapter!
The ability to work with data and the systems that store it is a fundamental career skill and will remain one for many years to come. Understanding MySQL and MariaDB is an upcoming book that will guide you in learning about two of the most popular database software titles in the world today. More than a textbook, it will combine quality instruction with online resources to help you understand the concepts you need to work with database technology and add more skills to your resume.