"Problem solving" connection MySQL 8 error: Authentication plugin ' Caching_sha2_password

When the MYSQL8 is just installed, the error when using the native connection

Authentication plugin ' Caching_sha2_password ' ...

First make sure the service is turned on and then go to MySQL's localhost database with the cmd command

mysql-hlocalhost-uroot-p123456

Then go to MySQL Database

Use MySQL;

Change Password

ALTER USER ' root ' @ ' localhost ' identified with mysql_native_password by '; FLUSH privileges;

Reconnect the database

OK Solution

"Problem solving" connection MySQL 8 error: Authentication plugin ' Caching_sha2_password