mysql 8.0.19 win10 quick installation tutorial

mysql 8.0.19 win10 quick installation tutorial

This tutorial shares the installation tutorial of MySQL 8.0.19 for your reference. The specific content is as follows

1. Download the .zip installation file

2. The root directory stores my.ini, and the file path is separated by "/" , for example:

[mysqld]
port=3306
basedir=F:/mysql-8.0.19-winx64/bin
datadir=F:/mysql-8.0.19-winx64/data
max_connections=200
max_connect_errors=10
character-set-server=UTF8MB4
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
[mysql]
default-character-set=UTF8MB4
[client]
port=3306
default-character-set=UTF8MB4

3.cd to bin , run mysqld --initialize --console , and when an error occurs, copy the share/english content in the root directory to the specified content according to the error message. Remember to generate password
4. Execute mysqld --install
5. Execute the command net start mysql to start the service
6.mysql -u root -p
7.Change the root password: alter user root@localhost identified by 'newpassward';

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • MySQL 8.0.19 installation and configuration tutorial under Windows 10
  • MySQL 8.0.19 winx64 installation tutorial and change the initial password under Windows 10
  • MySQL 8.0.19 installation and configuration method graphic tutorial
  • mysql 8.0.19 winx64.zip installation tutorial
  • MySQL 8.0.19 Installation Tutorial
  • MySQL 8.0.19 installation detailed tutorial (windows 64 bit)

<<:  Native JS realizes uniform motion of various sports

>>:  Network management and network isolation implementation of Docker containers

Blog    

Recommend

Webpack builds scaffolding to package TypeScript code

Create a folder Directory structure: dabaots Init...

Table paging function implemented by Vue2.0+ElementUI+PageHelper

Preface I have been working on some front-end pro...

Implementation of React configuration sub-routing

1. The component First.js has subcomponents: impo...

Summary of methods to check whether the port is open in Linux

Method 1: Use lsof command We can use the lsof co...

CSS sets Overflow to hide the scroll bar while allowing scrolling

CSS sets Overflow to hide the scroll bar while al...

SQL-based query statements

Table of contents 1. Basic SELECT statement 1. Qu...

Commonplace talk about MySQL event scheduler (must read)

Overview MySQL also has its own event scheduler, ...

Common tags in XHTML

What are XHTML tags? XHTML tag elements are the b...

JS deep and shallow copy details

Table of contents 1. What does shallow copy mean?...

In-depth explanation of the global status of WeChat applet

Preface In WeChat applet, you can use globalData ...

Linux kernel device driver advanced character device driver notes

/****************** * Advanced character device d...

Installation and use of Apache stress testing tools

1. Download Go to the Apache official website htt...

The qualities and abilities a web designer should have

Web design is an emerging marginal industry that c...