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

A brief discussion on the difference between src and href in HTML

Simply put, src means "I want to load this r...

Docker and portainer configuration methods under Linux

1. Install and use Docer CE This article takes Ce...

Exploring the practical value of the CSS property *-gradient

Let me first introduce an interesting property - ...

How to hide the version number in Nginx

Nginx hides version number In a production enviro...

Add ico mirror code to html (favicon.ico is placed in the root directory)

Code: Copy code The code is as follows: <!DOCTY...

Solution to "No input file specified" in nginx+php

Today, the error "No input file specified&qu...

WeChat applet implements simple calculator function

WeChat applet: Simple calculator, for your refere...

WeChat applet implements simple chat room

This article shares the specific code of the WeCh...

How to understand the difference between ref toRef and toRefs in Vue3

Table of contents 1. Basics 1.ref 2. toRef 3. toR...

Detailed explanation of docker compose usage

Table of contents Docker Compose usage scenarios ...

Web page creation basic declaration document type description (DTD

Using CSS layout to create web pages that comply w...