Detailed installation process of mysql5.7.21 under win10

Detailed installation process of mysql5.7.21 under win10

This article shares the installation of MySQL 5.7.21 and the problems encountered during the installation process for your reference. The specific content is as follows

1. I downloaded mysql-5.7.21-winx64, which is a free installation version, but I need to configure the my.ini file and create a new data folder, which I will talk about later.
Download

2. After downloading, unzip the file and place the unzipped folder where you want. Mine is: G:\softwareSetUp\mysql\mysql-5.7.21-winx64

3. Configure the path environment variable, including two paths: G:\softwareSetUp\mysql\mysql-5.7.21-winx64\bin;
C:\Windows\System32
If you do not configure C:\Windows\System32, you will be prompted when you run net start mysql that "net" is not recognized as an internal or external command.

4. Create a new my.ini text under mysql-5.7.21-winx64. The text content is as follows:


After saving, create a new data folder in the same directory

5. Run the command prompt as an administrator and execute mysqld install


6. Enter G:\softwareSetUp\mysql\mysql-5.7.21-winx64\bin
Run mysqld --initialize-insecure --user=mysql
There will be no prompt at the end of the run. Check whether the directories under the my.ini and data folders are correct.


7. Run net start mysql to start the MySQL service. It will prompt that the service is started successfully.

8. Run mysql -u root –p to log in to MySQL.

Problem encountered: The environment variable C:\Windows\System32 is not configured, and running net start mysql prompts "net" is not recognized as an internal or external command.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • How to fix abnormal startup of mysql5.7.21
  • mysql5.7.21 utf8 encoding problem and solution in Mac environment
  • MySql5.7.21 installation points record notes
  • Installation tutorial of mysql5.7.21 decompression version under win10
  • Detailed tutorial for installing mysql5.7.21 under Windows
  • MySQL 5.7.21 installation and password configuration tutorial
  • Detailed tutorial for installing mysql5.7.21 under Windows system
  • MySQL 5.7.21 installation and configuration tutorial
  • mysql5.7.21.zip installation tutorial
  • mysql installer web community 5.7.21.0.msi installation graphic tutorial

<<:  Execute initialization sql when docker mysql starts

>>:  Detailed explanation of Vue's SSR server-side rendering example

Recommend

Summary of data interaction between Docker container and host

Preface When using Docker in a production environ...

How to use vue filter

Table of contents Overview Defining filters Use o...

HTML table tag tutorial (11): horizontal alignment attribute ALIGN

In the horizontal direction, you can set the alig...

How to unify the character set on an existing mysql database

Preface In the database, some data tables and dat...

Understanding of CSS selector weight (personal test)

Copy code The code is as follows: <style type=...

Vue.js implements tab switching and color change operation explanation

When implementing this function, the method I bor...

MySQL 5.7.18 download and installation process detailed instructions

MySql Download 1. Open the official website and f...

JavaScript implements mouse control of free moving window

This article shares the specific code of JavaScri...

Detailed explanation of the use of state in React's three major attributes

Table of contents Class Component Functional Comp...

An example of how Tomcat manages Session

Learned ConcurrentHashMap but don’t know how to a...

How to modify the master-slave replication options in MySQL online

Preface: The most commonly used architecture of M...

Sample code for implementing horizontal infinite scrolling with pure CSS3

The examples in this article are all written in s...

Detailed explanation of group by and having in MySQL

The GROUP BY syntax can group and count the query...