Steps to install MySQL Server in Windows 11 environment (recommended collection)

Directory

illustrate:

There are several problems you may encounter:

1. Download the installation package

2. Installation

3. Tool connection

Description:

If there is already a MySQL database on your computer, there is no need to install it, whether it is Windows, Linux or Docker, whether it is 5.7 or 8.0. If the MySQL database that comes with phpstudy can be started, it can also be used, otherwise you have to install it yourself.

Due to different environments, you may encounter various problems during the installation process. Don’t panic. Search according to the error prompts first and try more.

Several problems you may encounter:

1. Certificate chain problems generally occur in the win7 operating system. It may be caused by the operating system version being too old. It is recommended to install using a virtual machine or docker.

2. .NET framework dependency problems can generally be solved by automatic download and installation. Otherwise, you can use tools such as XX Software Manager to download and install it. If it still doesn’t work after installation, consider other installation methods.

3. After installation, enter the mysql command and it does not exist. This is caused by the MySQL environment variables not being configured properly. Search for how to solve it yourself.

1. Download the installation package

Download address: https://dev.mysql.com/downloads/mysql/

The home page is the latest version 8.0. If you install version 5.x, you need to click the link on the right:

Enter download page

The actual download address is:

https://downloads.mysql.com/archives/get/p/25/file/mysql-installer-community-5.7.31.0.msi

If the webpage is slow to download, you can copy it to Thunder and download it.

2. Installation

After the download is complete, go to your download directory and click the .msi file to start the installation.

Select Custom to customize the installation

Note: If you find that there is no Next button during the installation process, the system resolution is scaled.

question. Pressing the N key solves this problem.

Expand MySQL Server, click MySQL Server x64, click the green arrow,

Add to the to-be-installed list.

Expand MySQL Server x64 on the right and uncheck Development Components (if it cannot be expanded, it will not affect it, just select all)

Click Execute to start the installation

After the installation is complete, Next enter the configuration

Next

Standalone, stand-alone mode (default)

Leave all as default

Set password for root user, next

If you do not need to start the computer, uncheck Start the MySQL…, next.

Execute

Finish, followed by Next

Next

Finish

The configuration file of MySQL Server in Windows environment is my.ini, usually in

In the MySQL installation directory.

For example: C:\ProgramData\MySQL\MySQL Server 5.7

3. Tool connection

There is a Navicat compressed package in the network disk.

Install navicat112_premium_cs_x64.exe first, and it will not start after installation.

Run PatchNavicat.exe again to crack

Right-click in the blank space on the left – New Connection – MySQL

  • Connection name: It is used to distinguish, choose it casually, such as aliyun131, docker168
  • Host name: This machine is localhost, no need to change it, fill in the remote IP
  • Port: 3306 if not changed

After configuring, you can click the connection test first. If the connection is successful, confirm and save.

live. In the future, just double-click to open the connection.

CMD client connection method:

mysql -uroot -p123456

bye or quit or close the window to exit the connection

In fact, it is not difficult to choose the direction of network security learning and how to combine practice with theory. It is important to find the right method.

Next, I will take you step by step to unveil the mystery of network security, starting from the growth route.

1. Growth roadmap

It can be divided into:

1. Basic stage

2. Penetration stage

3. Safety management

4. Upgrade stage

At the same time, supporting videos are provided for each section corresponding to the growth route:

Video supporting materials & domestic and foreign cybersecurity books and documents

Of course, in addition to supporting videos, we have also compiled various documents and books for everyone.
Summary of SRC technical documents

Green Alliance Network Protection Action

Network security source code collection + toolkit

Cybersecurity interview questions

Finally, there is the section of network security interview questions that everyone is most concerned about.


All materials total 87.9G. If you need the full set of “Introduction to Network Security + Advanced Learning Resource Pack”, you can scan the CSDN official cooperation QR code below to get it for free (if you encounter problems with scanning the code, you can leave a message in the comment area to get it) ~

If you are interested in getting started with network security, you can click here if you need it Big benefits of network security: Getting started & advanced full set of 282G learning resource package to share for free!