Detailed explanation of the standard MySQL (x64) Windows version installation process

Detailed explanation of the standard MySQL (x64) Windows version installation process

MySQL x64 does not provide an installer, does not provide an installer, does not provide an installer...

It’s a bit slow and not simple enough to check English documents every time.

There is no data directory when you unzip the 64-bit zip package after downloading 5.7.6.

Enter the unzipped bin directory: (I used powershell)

Initialize the data directory (a password will be randomly assigned, write it down)

.\mysqld --initialize --console

Installation service (automatically started service, only installed, not started)

.\mysqld --install
--install-manual is manual startup, --remove is uninstall service

start up

net start mysql

Initialize security settings

.\mysql_secure_installation.exe

They are old password, new password, confirm new password, delete anonymous account, disable root remote access, delete test database, and update permission table.

Client login

./mysql -u root -p

Enter new password

Summarize

The above is the standard MySQL (x64) Windows version installation process 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!

You may also be interested in:
  • MySQL 5.6.36 Windows x64 version installation tutorial detailed
  • mysql5.7.18.zip Installation-free version configuration tutorial (windows)
  • Tutorial on installing mysql5.7.18 on windows10
  • Graphic tutorial for installing MySQL 5.6.35 on Windows 10 64-bit
  • Steps to install MySQL 5.7.10 on Windows server 2008 r2
  • MySQL 5.7.17 installation and configuration method graphic tutorial (windows)
  • Tutorial on installing mysql5.7.17 on windows10
  • MySQL 5.7 installation tutorial (windows)

<<:  Docker data storage tmpfs mounts detailed explanation

>>:  Detailed explanation of the initial use of Promise in JavaScript asynchronous programming

Recommend

WeChat applet implements a simple handwritten signature component

Table of contents background: need: Effect 1. Ide...

Specific use of MySQL internal temporary tables

Table of contents UNION Table initialization Exec...

Implementing login page based on layui

This article example shares the specific code of ...

The process of installing MySQL 8.0.26 on CentOS7

1. First, download the corresponding database fro...

Sharing tips on using vue element and nuxt

1. Element time selection submission format conve...

Detailed explanation of the use of MySQL DML statements

Preface: In the previous article, we mainly intro...

Common date comparison and calculation functions in MySQL

Implementation of time comparison in MySql unix_t...

Command to view binlog file creation time in Linux

Table of contents background analyze method backg...

MySQL foreign key (FOREIGN KEY) usage case detailed explanation

Introduction: The disadvantages of storing all da...

Solution to Incorrect string value in MySQL

Many friends will report the following error when...

Tutorial for installing MySQL 8.0.18 under Windows (Community Edition)

This article briefly introduces how to install My...