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

MySQL 8.0.24 installation and configuration method graphic tutorial

This article shares the installation tutorial of ...

Introduction to SSL certificate installation and deployment steps under Nginx

Table of contents Problem description: Installati...

Example of customizing the style of the form file selection box

Copy code The code is as follows: <!DOCTYPE ht...

Detailed explanation of Mysql transaction processing

1. MySQL transaction concept MySQL transactions a...

Detailed explanation of various join summaries of SQL

SQL Left Join, Right Join, Inner Join, and Natura...

Solution to Mysql binlog log file being too large

Table of contents 1. Related binlog configuration...

CocosCreator Universal Framework Design Network

Table of contents Preface Using websocket Constru...

Detailed explanation of the difference between JavaScript onclick and click

Table of contents Why is addEventListener needed?...

About nginx to implement jira reverse proxy

Summary: Configure nginx reverse proxy jira and i...

Example code for implementing equal width layout in multiple ways using CSS

The equal-width layout described in this article ...

Detailed explanation of how to use Teleport, a built-in component of Vue3

Table of contents 1. Teleport usage 2. Complete t...