Shulou(Shulou.com)06/01 Report--

This article shares the mysql 8.0.17 installation tutorials for your reference. The details are as follows

Installation environment: windows x64

1. Download the installation package

Download address: install package

two。 Decompression and initialization configuration

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

Enter the following in the initialization configuration file, and note that the installation path and data storage path are changed to your own.

[mysqld]\ # set port 3306 port=3306\ # set the installation directory of mysql:\ App\ mySQL\ # set the directory where mysql database data is stored datadir=D:\ App\ mySQL\ data\ # maximum number of connections allowed max_connections=200\ # the number of connections allowed to fail. The character set used by the max_connect_errors=10\ # server defaults to utf8mb4character-set-server=utf8mb4\ # the default storage engine default-storage-engine=INNODB\ # that will be used when creating a new table uses the "mysql_native_password" plug-in authentication\ # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL]\ # set the mysql client default character set default-character-set=utf8mb4 [client]\ # set the mysql client connection server The port port=3306default-character-set=utf8mb4 used by default when

3. Start installation

Open cmd as an administrator for installation

First go to the bin directory

Enter the command mysqld-- initialize-- console enter, and the following field appears, in which root@localhost: the following field is followed by the initial password, copy and save!

Then install the mysql service and run mysqld in the bin directory-- install without the service name, default is mysql

It's a success when you get here!

4. Start the mySQL service

Type: net start mysql on the command line and you can start it!

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.