Installation of MySQL 8.0.17

Time:2021-2-18

This article has shared the MySQL 8.0.17 installation picture and text tutorial for your reference, the specific content is as follows

Installation environment:windows x64

1. Download the installation package

Download address: installation package

2. Decompression and initialization configuration

Unzip and create a new initialization configuration file in the root directory my.ini

Enter the following contents in the initialization configuration file. Pay attention to change the installation path and data storage path to your own

[mysqld]
\#Set port 3306
port=3306
\#Set the installation directory of MySQL
basedir=D:\App\mySQL
\#Set the data storage directory of MySQL database
datadir=D:\App\mySQL\data
\#Maximum number of connections allowed
max_connections=200
\#The number of connection failures allowed.
max_connect_errors=10
\#The character set used by the server is utf8mb4 by default
character-set-server=utf8mb4
\#The default storage engine that will be used when creating new tables
default-storage-engine=INNODB
\#The default is "MySQL"_ native_ "Password" plug-in authentication
\#mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
\#Setting the default character set of MySQL client
default-character-set=utf8mb4
[client]
\#Set the default port for MySQL client to connect to the server
port=3306
default-character-set=utf8mb4

3. Start installation

Open CMD as administrator to install

First, enter the bin directory

Input commandmysqld –initialize –consoleEnter to display the following fields, where[email protected]:The following field is the initial password, copy and save!

Then install the MySQL service and run it in the bin directorymysqld –installThere is no service name added here. The default is mysql

It’s a success here!

4. Start MySQL service

In the command line input: Net start MySQL can start it!

Wonderful topic sharing:

Installation of different versions of MySQL

Installation tutorial of mysql5.7

Installation tutorial of mysql5.6

Installation tutorial of mysql8.0

The above is the whole content of this article, I hope to help you learn, and I hope you can support developer more.

Recommended Today

Implementation example of go operation etcd

etcdIt is an open-source, distributed key value pair data storage system, which provides shared configuration, service registration and discovery. This paper mainly introduces the installation and use of etcd. Etcdetcd introduction etcdIt is an open source and highly available distributed key value storage system developed with go language, which can be used to configure sharing […]