Mysql 8.0.15 installation configuration graphic text tutorial

This article records the installation and configuration of mysql 8.0.15 for your reference. The details are as follows.

Download the installation package

Link: download address of MySQL official website

The difference between the first Download, the first installation package and the second installation package is that the first file is the zip file, which is step-free, and the second is the msi file, which is used for installation. The zip installation method is selected here.

The downloaded icons are as follows:

Extract the installation file

Extract to E:\ MySQL\ mysql-8.0.15-winx64

And add the bin directory under this file to the environment variable

Add a my.ini file

The contents of the file are written as follows:

[client] port = 3308default-character-set = UTF8MB4 [mysqld] port = 3308character-set-server = UTF8MB4 basedir=E:\ MySQL\ mysql-8.0.15-winx64datadir=E:\ MySQL\ mysql-8.0.15-winx64\ data group_concat_max_len=20000 [WinMySQLAdmin] E:\ MySQL\ mysql-8.0.15-winx64\ bin\ mysqld.exe

Open cmd as an administrator

Execute the command in the bin directory of the MySQL installation directory:

Mysqld-initialize-console

When the execution is complete, the initial default password of the root user will be printed and remembered, which will be used later.

A temporary password is generated for root@localhost: *

Execute the command:

Mysqld-install MySQL

Start the service:

Net start MySQL

Change password

Execute the command in the bin directory of the MySQL installation directory:

Mysql-u root-p

Will be prompted for a password, and then enter the above default initial password

Enter mysql >

Execute the command to change the password to 123456

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456'

Installation and deployment complete

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.