MySql5.7.21 installation points record notes

MySql5.7.21 installation points record notes

The downloaded version is the Zip decompression version, Windows system. Because I haven't installed it on Windows for a long time, I found several differences between this installation and the previous installation. I have recorded them as follows for your reference.

MySQL Configuration File Location

mysql_config.pl in the bin directory

Install MySQL Service

Enter the bin directory

mysqld --install
mysqld --remove

MySQL Initialization

mysqld --explicit_defaults_for_timestamp --initialize

Random password

Generated location: 507B9DE08DE0.err in the data directory. Search for "temporary password" in the file ending with err to get a random password. After logging in with this password, the MySQL security policy will require you to change the password. Change command

alter user root@localhost identified by '123456';

Summarize

The above is the installation notes of MySql5.7.21 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:
  • How to fix abnormal startup of mysql5.7.21
  • mysql5.7.21 utf8 encoding problem and solution in Mac environment
  • 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 installation process of mysql5.7.21 under win10
  • 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

<<:  Summary of some common configurations and techniques of Nginx

>>:  React configuration px conversion rem method

Recommend

Example analysis of mysql shared lock and exclusive lock usage

This article uses examples to illustrate the usag...

HTML line spacing setting methods and problems

To set the line spacing of <p></p>, us...

Shell script settings to prevent brute force ssh

The shell script sets access control, and the IP ...

The easiest way to make a program run automatically at startup in Linux

I collected a lot of them, but all ended in failu...

How to implement a single file component in JS

Table of contents Overview Single file components...

How to implement Docker container self-start

Container auto-start Docker provides a restart po...

MySQL Basic Tutorial Part 1 MySQL5.7.18 Installation and Connection Tutorial

Starting from this article, a new series of artic...

Research on the problem of flip navigation with tilted mouse

In this article, we will analyze the production of...

Detailed example of using if statement in mysql stored procedure

This article uses an example to illustrate the us...

Solution to the low writing efficiency of AIX mounted NFS

Services provided by NFS Mount: Enable the /usr/s...

Understanding Nginx Current Limitation in One Article (Simple Implementation)

Nginx is now one of the most popular load balance...

Summary of Docker configuration container location and tips

Tips for using Docker 1. Clean up all stopped doc...