Complete step-by-step record of MySQL 8.0.26 installation and uninstallation

Preface

MySQL 8.0.26 was released on July 20, 2021.

One change you need to note is that a lot of variable names have been changed in this version. A lot of variable names containing master and slave have been changed to source and replica. For example: slave_parallel_workers ->replica_parallel_workers.

The following is a detailed introduction to the installation and uninstallation methods.

1. Installation

1. Download from the official website

Baidu enters the official website, the community version is enough for learning, I downloaded the compressed version click here to go directly to the download page

It is said that version 8.X has optimized performance and is 2 times faster than version 5.7!

Next, download without logging in

2. Create configuration

After downloading, it is recommended to unzip it to a path without Chinese characters and create a my.ini configuration file in the unzipped directory

# These are the basic configuration information
[client]
# Set the default character set for the mysql client
default-character-set=utf8

[mysqld]
# Set port 3306. I used 3306 in version 5.7, so I use 3307 here.
port = 3307
# Set the installation directory of mysql
basedir=D:\developer\developer_tools\MySQL\mysql-8.0.26-winx64
# Set the storage directory for mysql database data
datadir=D:\developer\developer_tools\MySQLData\mysql-8.0.26-winx64
# Maximum number of connections allowed
max_connections=20
# The default character set used by the server is the 8-bit latin1 character set
character-set-server=utf8
# The default storage engine that will be used when creating new tables
default-storage-engine=INNODB

3. Initialize MySQL

The administrator CMD enters the unzipped bin directory and enters mysqld --initialize --console

4. Install MySQL service

Enter mysqld --install 服務名If you do not enter a service name, the default is mysql.

5. Log in to MySQL

Start the service first

Log in to the specified port, because 3306 is used by version 5.7

Change the password. The password just generated is a temporary password and needs to be changed.

Enter ALTER USER "root"@"localhost" IDENTIFIED BY "新密碼";

The installation is now complete.

2. Uninstall

1. Stop the service

Administrator CMD, enter net stop mysql , I have two services running, so net stop mysql2

Select the version you want to delete and click OK

2. Uninstall the service

I chose to delete the second one.

3. Delete the installation files

Delete both the installation directory and the data directory.

4. Delete registry information

Registry Path

• HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\
• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\

Summarize

This is the end of this article about MySQL 8.0.26 installation and uninstallation. For more information about MySQL 8.0.26 installation and uninstallation, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!