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

1. MySql 8.0.18 installation

1. Baidu searches for windows for mysql

two。 Select MySQL:: Download MySQL Installer

3. Choose to download the second (mysql-installer-community-8.0.18.0.msi)

4. No need to register, just start downloading

5. Install the right mouse button after the download is completed

6. Click to run

7. Check and agree to click next.

8. Check Custom customization and click next

9. Select MySQL Servers > MySQL Server > MySQL Server 8.0.18-X64 to the right, and click next

10. Click Execute, click next

11. Click Execute

twelve。 Click next

13. Click next

14. Click next

15. Click next

16. Click next

17. Set the root password (be sure to remember it) and click next after setting it.

18. Click next

19. Select Execute

20. Click finish when all the buttons turn green

21. Click next

twenty-two。 Click finish to complete the installation

Second, configure environment variables

1. Right-click my computer properties to select advanced system settings

two。 Click the environment variable

3. Select Path (path) in the system variable and click Edit

4. Click New

5. Then click to browse

6. Select the installed MySQL bin directory. The default directory of the system is (C:\ Program Files\ MySQL\ MySQL Server 8.0\ bin). Click OK to complete the setting of environment variables.

III. Connection testing

1. Open Navicat and click MySQL under the connection

two。 Enter the following (the connection name is randomly selected, the host name IP address is entered in localhost on this machine, the port is 3306 by default at installation, the user name is root, and the password is the password at installation), and the click connection test is completed.

3. If the connection is successful as shown below, it means that MySQL can connect and use normally.

4. If the following error occurs (2059-Authentication plugin 'caching_sha2_password' cannot be loaded)

5. This is because in the previous version of mysql8, the encryption rule is mysql_native_password, but after mysql8, the encryption rule is caching_sha2_password. There are two ways to solve the problem, one is to upgrade the navicat driver, and the other is to restore the mysql user login password encryption rule to mysql_native_password.

We use the second approach here, and the solution is as follows:

6. Run the CMD command prompt as an administrator

7. Enter the command mysql-u root-p to log in to MySQL

8. Enter the password after password. This password is the password of the root account when MySQL is installed. After successful login, the password is as follows

9. Modify encryption rules to update user passwords and refresh permissions (it is recommended to copy the code directly)

# modify the encryption rules ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER;# update the user's password ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password';# refresh permission FLUSH PRIVILEGES

10. The results of successful implementation of these three steps are as follows:

11. Reset password

# reset password (here reset 111111, according to your custom setting, try not to be too complicated so as not to forget) alter user 'root'@'localhost' identified by' 111111 password # exit MySQL/q

twelve。 Continue with the third step connection test after the reset is complete

Summary

The above is the detailed description of the visual installation tutorial of MySql Installer 8.0.18 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and 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!

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.