Tutorial for installing MySQL 8.0.18 under Windows (Community Edition)

Tutorial for installing MySQL 8.0.18 under Windows (Community Edition)

This article briefly introduces how to install MySQL under Windows. If you have other questions, please leave a message in time.

1. Download

Official website download address: MySQL Community Server 8.0.18

insert image description here

2. Installation

After downloading, unzip it and use cmd with administrator privileges to enter the mysql bin directory;

Enter the following command:

mysqld --initialize --console displays the local user and password of mysql mysqld --install installs mysql -u root -p to enter the database

Change new password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';

Log in to the database normally and the installation is complete.

Summarize

The above is the tutorial on installing MySQL 8.0.18 under Windows 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!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • MySQL 8.0.18 installation and configuration method graphic tutorial under win10 (windows version)
  • MySQL 8.0.18 installation tutorial under Windows (illustration)
  • mysql 8.0.18.zip installation and configuration method graphic tutorial (windows 64 bit)
  • Installation method of mysql-8.0.17-winx64 under windows 10
  • MySQL 8.0.13 free installation version configuration tutorial under Windows environment
  • Solve the problems encountered when installing mysql-8.0.11-winx64 in Windows environment
  • Tutorial diagram of installing MySQL service through MySQL Installer under Windows

<<:  How to configure environment variables in Linux environment

>>:  JS implements layout conversion in animation

Recommend

HTML Frameset Example Code

This article introduces a framework made by Frame...

Web page printing thin line table + page printing ultimate strategy

When I was printing for a client recently, he aske...

How does Vue implement communication between components?

Table of contents 1. Communication between father...

WeChat applet implements sorting function based on date and time

I recently took over a small program project, and...

Summary of MySQL commonly used type conversion functions (recommended)

1. Concat function. Commonly used connection stri...

HTML tutorial, easy to learn HTML language

1. <body background=image file name bgcolor=co...

MySQL sql_mode analysis and setting explanation

When inserting a set of data into the MySQL datab...

Detailed Tutorial on Installing MySQL 5.7 on RedHat 6.5

RedHat6.5 installation MySQL5.7 tutorial sharing,...

DIV common attributes collection

1. Property List Copy code The code is as follows:...

How does the MySQL database implement the XA specification?

MySQL consistency log What happens to uncommitted...

Detailed explanation of JSONObject usage

JSONObject is just a data structure, which can be...

Use of Linux crontab command

1. Command Introduction The contab (cron table) c...