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

Docker image import and export code examples

Import and export of Docker images This article i...

Automatically load kernel module overlayfs operation at CentOS startup

To automatically load kernel modules in CentOS, y...

40 fonts recommended for famous website logos

Do you know what fonts are used in the logo desig...

How to use the realip module in Nginx basic learning

Preface There are two types of nginx modules, off...

Sharing of SVN service backup operation steps

SVN service backup steps 1. Prepare the source se...

3 ways to create JavaScript objects

Table of contents 1. Object literals 2. The new k...

Detailed explanation of CSS label mode display property

The code looks like this: <!DOCTYPE html> &...

MySQL login and exit command format

The command format for mysql login is: mysql -h [...

Solution to the data asymmetry problem between MySQL and Elasticsearch

Solution to the data asymmetry problem between My...

Database query which object contains which field method statement

The database queries which object contains which ...

How to create Apache image using Dockerfile

Table of contents 1. Docker Image 2. Create an in...