MySQL 8.0.21 free installation version configuration method graphic tutorial

MySQL 8.0.21 free installation version configuration method graphic tutorial

Six steps to install MySQL (only the installation package can choose the installation location), for your reference, the specific contents are as follows

Step 1: Download the MySQL compressed package

mysql download path

You can also download it by clicking the link directly: mysql 8.0.21

Step 2: Unzip to the location you want to install

Step 3: Add environment variables (no need to cd to the directory in the following steps)

Add the bin directory to the system variables (this step is for convenience. It can be omitted)

Step 4: Create the my.ini configuration file and move it to the directory to be installed

File contents:

[mysql]
# Set the default character encoding of the mysql client to default-character-set=utf8mb4
[mysqld]
#Set the port number, default is 3306
port = 3306
# Set the installation directory of mysql basedir=D:\MySQL\mysql-8.0.21-winx64
# Set the data storage directory of MySQL database datadir=D:\MySQL\mysql-8.0.21-winx64\data
# Set the maximum number of connections max_connections=200
# The number of connection failures allowed is max_connect_errors=10
# The default character set used by the server is utf8mb4
character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#Default authentication is done with the "mysql_native_password" plugin #mysql_native_password
default_authentication_plugin=mysql_native_password
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8mb4

Step 5: Initialize the database and install and log in to the database

First open the command prompt (cmd) as an administrator

1. Initialize the database

Generate the initial password, which is the characters after root@localhost. We need to write it down for later use.

mysqld --initialize --console 

2. Install the database

mysql --install 

At this point, there will be an additional data folder in the directory

3. Start the database and log in with the initial password:

//Start net start mysql 

//Login to mysql -u root -p 

Step 6: Change the password to complete the installation

Use SQL statements to modify, for example, to abcd

ALTER USER 'root'@'localhost' IDENTIFIED BY 'abcd';

Exit after the modification is completed:

exit;

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:
  • Some improvements in MySQL 8.0.24 Release Note
  • MySQL 8.0.23 installation and configuration method graphic tutorial under win10
  • MySQL 8.0.22 installation and configuration method graphic tutorial
  • MySQL 8.0.22 installation and configuration graphic tutorial
  • MySQL 8.0.22 download, installation and configuration method graphic tutorial
  • MySQL 8.0.22 installation and configuration method graphic tutorial under Windows 10
  • MySQL 8.0.22 winx64 installation and configuration method graphic tutorial
  • MySQL 8.0.21 installation and configuration method graphic tutorial
  • MySQL 8.0.20 Installation Tutorial with Pictures and Text (Windows 64-bit)
  • MySQL 8.0.20 installation and configuration detailed tutorial
  • MySQL 8.0.24 installation and configuration method graphic tutorial

<<:  js to implement a simple bullet screen system

>>:  Analysis of the process of configuring a simple network environment based on Tcl language

Recommend

Super detailed tutorial to implement Vue bottom navigation bar TabBar

Table of contents Project Introduction: Project D...

Solve the problem that the IP address obtained using nginx is 127.0.0.1

Get ip tool import lombok.extern.slf4j.Slf4j; imp...

Answers to several high-frequency MySQL interview questions

Preface: In interviews for various technical posi...

Tutorial on deploying springboot package in linux environment using docker

Because springboot has a built-in tomcat server, ...

Summary of naming conventions for HTML and CSS

CSS naming rules header: header Content: content/c...

Docker binding fixed IP/cross-host container mutual access operation

Preface Previously, static IPs assigned using pip...

Summarize the common application problems of XHTML code

Over a period of time, I found that many people d...

Summary of 16 XHTML1.0 and HTML Compatibility Guidelines

1. Avoid declaring the page as XML type . The pag...

Detailed tutorial on distributed operation of jmeter in docker environment

1. Build the basic image of jmeter The Dockerfile...

Common writing examples for MySQL and Oracle batch insert SQL

Table of contents For example: General writing: S...

Issues installing Python3 and Pip in ubuntu in Docker

text 1) Download the Ubuntu image docker pull ubu...

Interpreting MySQL client and server protocols

Table of contents MySQL Client/Server Protocol If...

Sample code for installing ASPNET.Core3.0 runtime in Linux

# The following examples are for x64-bit runtime ...

Example of how to implement MySQL cascading replication

The so-called cascading replication is that the m...

Mini Programs use Mini Program Cloud to implement WeChat payment functions

Table of contents 1. Open WeChat Pay 1.1 Affiliat...