Setting up MySQL server and tools

MySQL must be the most popular DBMS on the planet, although Gartner and other big-corporate-looking entities insist that it is Oracle. And most sysadmins will insist that it is actually PostGreSQL. But the sheer number of small businesses that use MySQL and do not care to report it belies their claims. After MySQL’s acquisition by Oracle, MariaDB was created and claims to be (almost) 100% compatible with MySQL. But for now we will use MySQL.

Download the MySQL community server here:

MySQL :: Download MySQL Installer

Then simply follow the instructions.

Click on the Local instance MySQL80 shaded area to open the password dialog.

Type the root password you set earlier and click OK. The MySQL Workbench front page opens.

Now let’s talk about the schema we are going to use.