How to install MySQL server community version MySQL 5.7.22 winx64 in win10

How to install MySQL server community version MySQL 5.7.22 winx64 in win10

Download: http://dev.mysql.com/downloads/mysql/


Unzip to drive C

Add environment variable path

Add environment variables

Right click My Computer -> Properties -> Advanced System Settings -> Advanced -> Environment Variables ->

Find the variable Path in the system variables, click Edit, and add the decompression path at the end of the variable value. The path should be to the path under the bin folder, such as:


Run cmd with administrator privileges

Install MySQL Service

Enter mysqld install in the cmd command window


Initialize the MySQL database, which will create the data directory just configured and some basic tables used by the database system

Enter mysqld --initialize --user=mysql --console in the cmd command to complete the initialization and generate a temporary password



Temporary password

Start MySQL Database

Enter net start MySQL in cmd


Enter MySQL

mysql -uroot -p Enter the temporary password here


Modify temporary password

Enter set password for root@localhost=password('Here is the password you want to change') in cmd command.


This way, when you log in again, you can use the password you set.

Summarize

The above is the graphic tutorial for installing MySQL server community version MySQL 5.7.22 winx64 under win10 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • iOS Assembly Tutorial - ARM64 Assembly Basics Tutorial
  • MySQL 5.7.22 binary package installation and installation-free version Windows configuration method
  • Ubuntu16.04 installation mysql5.7.22 graphic tutorial
  • Installation process of MySQL5.7.22 on Mac
  • The whole process of installing mysql5.7.22 under ARM64 architecture

<<:  How to test network speed with JavaScript

>>:  Interpretation of syslogd and syslog.conf files under Linux

Recommend

Solution for Docker container not recognizing fonts such as Songti

Problem background: When using docker to deploy t...

MySQL 8.0.12 installation and configuration method graphic tutorial (windows10)

This article records the installation graphic tut...

Detailed explanation of how a SQL statement is executed in MySQL

Overview I have recently started learning MySQL r...

Several common methods of sending requests using axios in React

Table of contents Install and introduce axios dep...

VUE introduces the implementation of using G2 charts

Table of contents About G2 Chart use Complete cod...

Linux swap partition (detailed explanation)

Table of contents linux 1. What is SWAP 2. What d...

Five delay methods for MySQL time blind injection

Five delay methods for MySQL time blind injection...

How to quickly insert 10 million records into MySQL

I heard that there is an interview question: How ...

Use pure CSS to disable the a tag in HTML without JavaScript

In fact, this problem has already popped up when I...

VMware Workstation is not compatible with Device/Credential Guard

When installing a virtual machine, a prompt appea...

Detailed explanation of MySQL injection without knowing the column name

Preface I feel like my mind is empty lately, as I...

Node.js+express message board function implementation example

Table of contents Message Board Required librarie...