RubyOnRails, Authentication plugin'caching_sha2_password' cannot be loaded error solution

** Ruby on rails ** When developing, I want to set database to mysql 8.0, and when I execute rails db: migrate with database.yml set to mysql, ** error "Authentication plugin'caching_sha2_password' cannot I will share the solution when it becomes "be loaded" **.

A similar error will occur in laravel.

Organize the environment

--Development environment: Windows10 Home 64-bit operating system, x64-based processor --Rails version 5 series

Mysql
- version 8.0
- user: root -** password: root (= this example) ** --RubyOnRails database.yml setting status

Cause

Since mysql 8.0, the authentication method uses caching_sha2_password. However, Rails didn't support this.

Method

** Change the authentication method of the target user from "caching_sha2_password" to "mysql_native_password". ** ** This time, user changes the root authentication method.

Access mysql with `mysql -u root -p`
Enter `root` (password this time) and press Enter.
Display the user list with `SELECT user, host, plugin FROM mysql.user;` and check it.

The root authentication method is "caching_sha2_password"

Execute ``` ALTER USER root IDENTIFIED WITH mysql_native_password BY'root';` ``.

Syntax: `ALTER USER username IDENTIFIED WITH mysql_native_password BY'password';`

Confirm that the root authentication method has been changed with `SELECT user, host, plugin FROM mysql.user;`.
Exit mysql with `` `exit```
Execute the rails migrate command of the main subject with `` `rails db: migrate```.
Completed without error.

Supplement: In my.ini (my.cnf on mac) default_authentication_plugin=caching_sha2_password To default_authentication_plugin=mysql_native_password It was said that if you change to, the error disappears, It didn't change when I restarted mysql after making the changes. By the way, the location of my.ini is "C: \ ProgramData \ MySQL \ MySQL Server 8.0".