Detailed installation steps for MySQL 8.0.11

This article shares the installation steps of MySQL 8.0.11 for your reference. The specific contents are as follows

Step 1: Download the installation package

MYSQL official download address: Official Download

The first option here is online installation, and the second option is offline package installation. I chose the second option (regardless of the operating system of your computer) because:
Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.

No need to register or log in, just select the lower left button to download: No thanks, just start my download

Step 2 : Installation

I choose Custom installation here, or you can choose Default

Because I did a custom installation, I only selected the following two installation contents

If the following prompt appears, it means that the machine does not have a VC environment, so the installation cannot proceed. You need to download the VC environment first.

Download VC environment: Official address If the address is invalid, you can also Baidu: microsoft visual c++ 2015 to download

After the environment is downloaded and installed, we come back and reinstall it, and find that this step will become

Next, install it all the way

The above step is to create a user, and then go down

After the installation is complete, you can see in the service that the MYSQL service has been started, the bin directory (default: C:\Program Files\MySQL\MySQL Server 8.0\bin)

But if we use a third-party application such as Navicat to log in, we will be prompted: Authentication plugin 'caching_sha2_password' cannot be loaded

After checking, it was found that 8.0 changed the authentication plugin

Solution

ALTER USER stocker@localhost IDENTIFIED WITH mysql_native_password BY 'stocker';

If it is the latest version of the third-party software, the authentication may have been changed automatically and no manual modification is required.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.