Installing MySQL and Setting Up the Environment

SQL Tutorials

The initial stage of learning about databases is installing MySQL, and setting up your environment. You first have to get your machine ready so that data can be stored, and your system can process commands issued in SQL. This article should be fairly comprehensible explaining you how to install MySQL on Windows, Linux, and Mac (iOS).

Installing MySQL on Windows

Step 1: Download MySQL for Windows

First, you should go to the official MySQL site and download MySQL Installer for Windows.
Choose the Community Edition, which is free and suitable for beginners.

Once you have downloaded, double click on the installer to start.

Step 2: Install MySQL Server

Then, follow the installer steps.

Select Developer Default or Server Only.
Proceed with the default options.

When prompted, create a root password and remember it.
Finally, finish the installation and let MySQL complete the setup.

Step 3: Verify MySQL Installation on Windows

Open Command Prompt and type:

mysql --version

If MySQL shows the version number, the installation is successful.

Step 4: Start Using MySQL on Windows

You can now open:

MySQL Command Line Client, or
MySQL Workbench for a graphical interface

Installing MySQL on Linux Using Terminal

Step 1: Update System Packages

First, open the terminal and update the package list.

sudo apt update

Step 2: Install MySQL Server

Next, install MySQL Server.

sudo apt install mysql-server

Press Y to continue.

Step 3: Start and Enable MySQL

Start the MySQL service.

sudo systemctl start mysql

Enable MySQL to start at boot.

sudo systemctl enable mysql

Step 4: Secure MySQL Installation

Improve security by running:

sudo mysql_secure_installation

Follow the on screen instructions.

Step 5: Log In to MySQL on Linux

sudo mysql

mysql -u root -p

Enter your password to begin.

Installing MySQL on macOS (iOS)

Note: MySQL runs on macOS, not directly on iOS devices like iPhone or iPad. This section explains setup on macOS.

Step 1: Download MySQL for macOS

First, visit the MySQL website and download MySQL Community Server for macOS.

Choose the DMG archive for easier installation.

Step 2: Install MySQL on macOS

Open the downloaded DMG file and follow the installer steps.

During installation:

Set a root password
Allow system permissions if asked

Finish the installation to complete setup.

Step 3: Verify MySQL Installation on macOS

Open Terminal and run:

mysql --version

If the version appears, MySQL is installed correctly.

Step 4: Start and Use MySQL on macOS

To log in to MySQL:

mysql -u root -p

Enter your password. Now you can start writing SQL queries.

You can also use MySQL Workbench for macOS for a visual interface.

Summary: MySQL Installation and Environment Setup

With MySQL installed and the environment set it is now possible to practice SQL across any of the major operating systems.
If using Windows you can use the MySQL Installer and Workbench.
Take a quick setup with command line for Linux users.
For macOS MySQL can be installed by the DMG installer or Workbench.