Shulou(Shulou.com)05/31 Report--

Editor to share with you mysql 8.0.11 compressed version of the installation configuration example analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

The details are as follows

Note:

Operating system: Windows 10 Professional Edition (64 bit)

MySQL version: mysql-8.0.11-winx64.zip

Download MySQL database

Download the community version archive file from the official website:

Official download address

2. Decompress the files

Extract the file you just downloaded, and I will extract it directly to the root directory of disk D, as shown below:

Third, configure system environment variables

In order for the Windows system to recognize the MySQL commands that we will use later here, we need to add environment variables to the current system:

Right click on my computer-> Properties-> Advanced system Settings-> Environment variables-> add the following to the Path of the system variable:

Fourth, install the MySQL database

1. In the lower left corner of the system, right-click the Windows logo and select "Command prompt (Administrator)":

Note: this must be the "administrator" to run the control console!

2. In the control console, go to the bin directory of the MySQL you just extracted:

3. Initialize the MySQL database

Method 1:

Command: mysqld-initialize-insecure

Purpose: initialize the database and set the default root password to empty

After initialization, the data folder is automatically generated in the mysql root directory, as shown in the following figure:

Note: initialization is complete only when the three folders shown above appear!

Method 2:

Command: mysqld-initialize

Function: initialize the database and set the default root password to an expired random password

At this point, the password of the database needs to be obtained in the following location: use notepad to open the file shown below:

The following figure shows a randomly generated password:

4. Install MySQL service for Windows system

Command: mysqld install

Purpose: install the MySQL service for the Windows system. The default service name is mysql

Note: if you want to delete the MySQL service, you can use the command "mysqld remove"

However, before deleting the MySQL service, you need to make sure that the MySQL service has been stopped.

After the installation is successful, you can view it in the "Control Panel-Administrative tools-Services" of the Windows system (note that it is not started at this time):

5. Start MySQL service command: net start mysql function: start MySQL service. Note that "mysql" at this time indicates the service name.

Note: if you want to stop the MySQL service, you can use the command "net stop mysql" to delete the MySQL service only after you have stopped the MySQL service.

At this point, the status of the service changes:

At this point, the MySQL compressed version of the database has been installed!

The above is all the contents of the article "sample Analysis of installation and configuration of mysql 8.0.11 compressed package". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.