Скачать или смотреть Installing MySQL 9.4 on Windows 11 with Workbench

What You’ll Learn:

Downloading MySQL Installer for Windows: We’ll begin by guiding you through how to download the official MySQL installer from the official MySQL website.
Installing MySQL on Windows 11: Once the installer is downloaded, we’ll show you the step-by-step process of installing MySQL, including configuring the necessary components like MySQL Server, MySQL Workbench, and MySQL Shell.
Configuring MySQL Server: We’ll guide you through configuring the MySQL server, setting up a root password, and configuring network options. You’ll also learn how to configure MySQL as a Windows service so that it starts automatically when your system boots.
Running MySQL Workbench: MySQL Workbench is a powerful tool for managing databases visually. We’ll walk you through how to launch it, connect to your MySQL server, and run your first SQL queries.
Testing the MySQL Installation: After the installation, we’ll show you how to verify that MySQL is running correctly by connecting to it using MySQL Workbench or the command line.

Key Steps:

1.
Download MySQL
Select the "MySQL Community Edition" for free use and download the MySQL Installer for Windows.

2.
Install MySQL:
Run the downloaded installer and choose "Development Computer" installation
Follow the prompts to install MySQL Server, MySQL Workbench, and any other necessary components.

3.
Configure MySQL Server:
Set up the root user password and choose whether to create additional users.
Configure networking settings (use default settings or customize based on your needs).
Set MySQL as a Windows service for easy management.

4.
Open MySQL Workbench:
After installation, open MySQL Workbench and connect to your MySQL server using your root credentials.
Execute a basic SQL query to verify the installation.

5.
Test MySQL via Command Line :
Open the MySQL command line client.
Login, choose a database and run a select query