KOSUNI KOREA
Korean News in English
Technology

[MySQL Tutorial] 2nd Lesson: Installing MySQL 8.x and Setting Up Your Development Environment

Published October 17, 2026 · 1 views
[MySQL Tutorial] 2nd Lesson: Installing MySQL 8.x and Setting Up Your Development Environment

[Mysql 강좌] MySQL 8.x 데이터베이스 입문 프롤로그 - 왜 데이터베이스를 배워야 할까요?

Why You Need to Prepare Your Development Environment First

Before learning programming, the first step is setting up your development environment.

No matter how good a tutorial you watch, it's hard to improve without hands-on practice.

Especially with databases, directly entering commands and checking results is crucial.

All SQL commands you'll learn will be practiced by running them yourself.

This lesson completes the setup needed for future practical exercises.


Why Use MySQL 8.x?

You'll still find many tutorials online using MySQL 5.x.

However, most new projects today are developed with MySQL 8.x as the standard.

MySQL 8.x includes numerous new features and significant performance improvements.

Key benefits include:

  • Performance enhancements

  • Strengthened security features

  • New SQL functionality

  • Improved default UTF-8 support

  • Better management tools

  • Enhanced index performance

If you're starting fresh, using the latest version is recommended.


Programs You Need to Install

To use MySQL, you'll need two main programs.

1. MySQL Server

This is the actual database server that stores data.

All information like user profiles, posts, and comments are stored inside the MySQL Server.

In simple terms, it acts as a warehouse for your data.


2. MySQL Workbench

This is a management program that makes using MySQL easier.

With Workbench, you can conveniently perform tasks like:

  • Creating databases

  • Creating tables

  • Writing SQL

  • Viewing results

  • Editing data

Newcomers will find it much easier to learn using Workbench alongside commands rather than relying solely on command-line interfaces.


How Will the Practical Exercises Proceed?

This lesson isn't just about learning SQL syntax—it follows how real developers work.

For example, you'll practice:

  • Creating a database

  • Creating tables

  • Storing data

  • Searching for data

  • Editing data

  • Deleting data

  • Connecting multiple tables

The more you practice, the more natural SQL will become.


Important Settings to Note During Installation

When installing for the first time, several settings appear.

Common settings include:

  • Admin (root) password

  • Port number

  • Character encoding

  • Service registration

While these might seem confusing at first, don't worry—this lesson uses the most commonly used default settings for beginners.

If you have no specific reason to change them, follow along with the tutorial's recommended settings.


What Is the Root Account?

During installation, you'll set a root password.

The root account is MySQL's highest-level administrator account.

Similar to creating an admin account when installing an operating system,

MySQL requires setting up an admin account first.

You can perform all tasks with this account, including:

  • Creating databases

  • Creating users

  • Managing permissions

  • Creating tables

So it's important to remember the password.


What Is a Port Number?

MySQL uses port 3306 by default.

A port is a number used for communication between programs on your computer.

For example, websites typically use:

  • Port 80

  • Port 443

Similarly, MySQL uses port 3306 by default.

Unless you have a specific reason to change it, stick with the default setting.


Character Encoding Matters Too

A common issue when using databases is Korean characters appearing as garbled text.

In the past, various character sets were used,

but now most systems use UTF-8 (utf8mb4).

Using utf8mb4 allows you to store:

  • Korean

  • English

  • Japanese

  • Chinese

  • Emojis 😊

This tutorial will use utf8mb4 as the standard for all exercises.


Exploring the MySQL Workbench Interface

After installation, launch MySQL Workbench to see its interface.

At first glance, it might look complex,

but most of what you'll use regularly is straightforward.

The key areas you'll frequently interact with include:

  • SQL input window

  • Execute button

  • Database list

  • Table list

  • Results pane

If you learn these five elements, you'll be able to handle most tasks.


Why Do Developers Type SQL Commands Directly?

While Workbench offers mouse-based features,

professionals typically type SQL commands directly.

The reasons are:

  • Faster workflow

  • Easier to repeat tasks

  • More precise control over the desired operation

This tutorial will help you develop the habit of typing SQL directly.

It may feel slow at first, but you'll quickly get used to it.


What's Next After Installation?

Your development environment is now ready.

The next lesson will begin using MySQL practically.

We'll start by creating a database,

then creating tables inside it,

and finally storing data directly through hands-on practice.

You'll learn step-by-step, just like real developers do.


Tip for Beginners

It's normal to encounter installation errors at first.

Don't worry—every developer experiences this during setup.

The important part is learning how to troubleshoot and solve these issues.

Gaining experience in identifying and fixing problems will be more valuable than getting everything perfect on the first try.

Follow along with the tutorial step by step rather than trying to set everything up perfectly from the start.


In Closing

This lesson covered installing MySQL 8.x and preparing your development environment for hands-on practice.

With your setup complete, it's time to create your first database.

The next lesson will teach you how to create a database (Database) and tables (Table), beginning your practical MySQL journey.

FAQ

Why should I use MySQL 8.x instead of older versions?

Most new projects today are built with MySQL 8.x, which offers performance improvements, enhanced security, and better UTF-8 support compared to older versions.

What is the default port for MySQL?

MySQL uses port 3306 by default. Unless you have a specific reason to change it, keep this setting as-is.

Why should I use utf8mb4 encoding?

utf8mb4 supports all languages including Korean, English, Japanese, Chinese, and emojis, preventing character encoding issues in your database.

Korean Source

This article is an English localization of a Korean-language report from BlogScore. Original: [Mysql 강좌] 2강 MySQL 8.x 설치와 개발 환경 구축하기