Shulou(Shulou.com)05/31 Report--

This article is about how to install and configure mysql8.0.11. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The details are as follows

1. Preface

   Oracle has released the release version of MySQL8.0GA,GA in foreign countries, that is, the official version, not the beta version.

   installation MySQL always sees a lot of services installed in addition to database services, so let's go through the MySQL installation process. When I tried to install MySQL8.0, I found that my navicat could not connect to MySQL8.0. After looking up the original MySQL8.0, I chose the new one when I installed it.

2. Install MySQL8.0

2.1.Adding services in mysql installer

Click the add button.

Select custom, then next, so you can choose the service you want to install.

Blame mysql server first, add it to to be installed, and then next the next step.

Next directly. If you need to change it, change it according to your own needs.

Click execute directly to perform the installation.

Installation is complete, next.

2.2.Configuring mysql

Next, start configuring mysql settings.

Default is fine, next.

There is no need, the default configuration can be, next, there are other requirements are usually to change the port.

There is no need to choose the previous encryption method, just came out 8.0, the third-party clients basically do not support this encryption method, but the built-in command line support, of course, I recommend this is the development environment, the server side you think about it, the development environment of the old encryption method will not have a pit, choose Use Legacy Authentication Method, then next, the next step

Enter the password of the root user, next.

Default is fine, next.

Click execute to write the configuration and add the windows service.

Click finish to complete the installation.

Then click next and finish to complete.

3. Start and stop the MySQL service

There is no detailed explanation here. Anyway, in the task manager's service tab, you can turn on and off the mysql service, which is self-starting by default. I let it start itself, because it doesn't take up much resources.

4. About the new password authentication method of MySQL8.0

The caching_sha2_password and sha256_password authentication plugins provide more secure password encryption than the mysql_native_password plugin, and caching_sha2_password provides better performance than sha256_password. Due to these superior security and performance characteristics of caching_sha2_password, it is as of MySQL 8.0 the preferred authentication plugin, and is also the default authentication plugin rather than mysql_native_password.

The caching_sha2_password and sha256_password authentication plug-ins are more secure than the password encryption provided by the mysql_native_password plug-in, and caching_sha2_password encryption is better than sha256 _ password encryption. Because of caching_sha2_password 's excellent security and performance features, it makes him the preferred authentication plug-in for MySQL8.0, which is also the default authentication plug-in rather than mysql_native_password.

Specifically, you can visit this caching_sha2_password Compatibility Issues and Solutions to learn that new encryption methods have been used and solutions that cannot be accessed are briefly summarized as follows:

1. Change the encryption method to the old one, and add the following to the configuration file my.conf:

[mysqld] default_authentication_plugin=mysql_native_password

2. Use a client (Client) that supports new encryption methods, such as libmysqlclient equal to or higher than version 8.0.4

3. Use the connection driver (Connector) that supports the new encryption method:

MySQL Connector/C++ 1.1.11 or higher or 8.0.7 or higher.MySQL Connector/J 8.0.9 or higher.MySQL Connector/NET 8.0.10 or higher (through the classic MySQL protocol). MySQL Connector/Node.js 8.0.9 or higher.

PHP: the X DevAPI PHP extension (mysql_xdevapi) supports caching_sha2_password.

4. The new encryption method is changed to the old encryption method, and root users have to make corresponding changes. Because root users are still the new addition method, use the alter statement to reset the password to overwrite the password of the new encryption method:

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

Password is the password of the root user you are about to set.

Thank you for reading! This is the end of this article on "how to install and configure mysql8.0.11". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.