Win10 64-bit tutorials for installing the latest MySQL8.0.18 using zip packs (illustrated in detail)

WIN10 64-bit installation of the latest MySQL8.0.18

download

Download the latest version on the official website:

The compressed package version I use here does not use a graphical installer

Download address: https://dev.mysql.com/downloads/mysql/

After downloading and decompressing directly to the location you want to use, it is best to put it on a disk with a solid-state hard disk. I bought a small solid-state disk at that time, poor, and there was not much space for disk C, so I put it directly on another disk.

Location to be placed after decompression:

E:\ MySQL\ mysql-8.0.18-winx64

Set the environment variable of the bin under it

E:\ MySQL\ mysql-8.0.18-winx64\ bin

Set up the profile my.ini

Create a new configuration file my.ini in the unzipped location

The configuration is as follows:

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

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

Mysqld-install MySQL

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: *

It should be noted that yes, the process will take a few minutes, and it will take a long time. Please wait patiently.

If you inadvertently repeat the instruction before it is completed, you can clear the following directory

E:\ MySQL\ mysql-8.0.18-winx64\ data

Then enter the mysqld-- install MySQL instruction again

Note that the following command requires administrator privileges

Execute installation command

Mysqld-install MySQL

If administrator privileges are not enabled in this directive in CMD, the following error will be reported

Mysql Install/Remove of the Service Denied!

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

You don't have to type it manually. When the password is generated, you can use the mouse to copy it somewhere else. Here you can paste it. That's what I did.

Enter mysql >

Input

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

Execute the command to change the password to 123456

Installation and deployment complete

Query the version of MYSQL installation

Query instruction:

Select version ()

The record is as follows:

Mysql > select version (); +-+ | version () | +-+ | 8.0.18 | +-+ 1 row in set (0.00 sec) installation steps

Due to the need to turn on administrator privileges, the previous instruction record is gone.

E:\ MySQL\ mysql-8.0.18-winx64\ bin > mysqld-- install MySQLService successfully installed.E:\ MySQL\ mysql-8.0.18-winx64\ bin > the net start MySQLMySQL service is starting.. the MySQL service has started successfully. E:\ MySQL\ mysql-8.0.18-winx64\ bin > mysql- u root-pEnter password: * Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 8Server version: 8.0.18Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456 query OK, 0 rows affected (0.11 sec) mysql >

Summary

The above is the editor to introduce to you the WIN10 64-bit use compressed package to install the latest MySQL8.0.18, I hope to help you, if you have any questions, please leave me a message, the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!