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

This article shares the installation steps of mysql 8.0.11 for your reference. The details are as follows

Step 1: download the installation package

Official download address of MYSQL: official download

The first item here is online installation, the second is offline package installation, and I choose the second (regardless of the number of operating systems on your computer), because:

Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.

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

Step 2, install

I choose Custom custom installation here, or I can choose Default default.

Because I am a custom installation, I have only chosen the following two installations

If the following prompt appears, which means that the machine does not have a VC environment, so that 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 download it from Baidu: microsoft visual C++ 2015.

After the environment has been downloaded and installed, we will come back to reinstall and find that this step will become

And then install it all the way.

The above step is to create a user and then move on

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

But at this point, if we log in with a third-party application such as Navicat, we will prompt: Authentication plugin 'caching_sha2_password' cannot be loaded

Upon inspection, it is found that 8.0 has changed the authentication plug-in.

Solution method

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

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

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.