MySQL 8.0 Installation Authentication Method

　　

1. Encrypt authorization with strong password (recommended)

8.0 provide the heart of the authorization method, using the SHA256 basis of password encryption methods.

But a new version of connector is needed, current and connector/j the latest 8.0

This new approach is supported by 8.0 of the current connectors and community-driven drivers using libmysqlclient8.0.

If clients and applications cannot be updated to support this new authorization method, you can choose to use traditional methods.

2. Traditional authorization method (preserves 5.x version compatibility)

Traditional methods are considered only in the following ways:

-the application cannot be upgraded to use MySQL 8 connector and driver. (Connectors and drives).

-Existing application recompilation is not feasible.

-New, language-specific connector/driver are not yet available.

Supposedly, I should use the new method. However, the traditional approach is taken into account in order to facilitate the use of older versions of Jar packages and various tools.

The new approach will significantly improve security.

There is no security requirement at this time.

MySQL 8.0 Installation Authentication Method