[MySQL Tutorial] 2nd Lesson: Installing MySQL 8.x and Setting Up Your Development Environment
![[MySQL Tutorial] 2nd Lesson: Installing MySQL 8.x and Setting Up Your Development Environment](/uploads/editor/Mysql-강좌-2강-MySQL-8-x-설치와-개발-환경-구축하기-20260703-21cbfb.webp)
![[Mysql 강좌] MySQL 8.x 데이터베이스 입문 프롤로그 - 왜 데이터베이스를 배워야 할까요?](/uploads/editor/Mysql-%EA%B0%95%EC%A2%8C-MySQL-8-x-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%9E%85%EB%AC%B8-%ED%94%84%EB%A1%A4%EB%A1%9C%EA%B7%B8-%EC%99%9C-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4%EB%A5%BC-%EB%B0%B0%EC%9B%8C%EC%95%BC-%ED%95%A0%EA%B9%8C%EC%9A%94-20260703-3f39d4.webp)
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 설치와 개발 환경 구축하기