Authentication method 'caching_sha2_password' not supported by any of the available plugins

1st

Modify the MySql Server:

1. Open MySQL Installer - Community
2. Select Product MySQL Server
3. Click on Quick configure in last column
4. Click on next untill you will not point to Authentication method
5. On Authentication method tab- select Use Legacy Authentication method
6. Click on next and finish

Now you can login with normal password

2nd

If you are using .net framework 4.5.2 you can easy upgrade reference of MySQL.Data:

1. Visulastudio> Tools> Nuget Package Manager>Manage nuget package for solution
2. Go to Browse tab, Write Search textbox mysql and enter first mysql.data package will come, install it

Now login, issue will resolved

This is a new authentication method used in MySQL version 8.0 as compared to mysql_native_password, which is the legacy method. In order to make this work, you will need to upgrade your MySQL Client library to version 8.0.

So, use the following link and get the version 8.0.11 or higher.

https://dev.mysql.com/downloads/connector/net/

Update the Pomelo.EntityFrameworkCore.MySql Nuget Package to 2.0.0.1 instead of 2.0.0

2.0.0.1 is more stable than 2.0.0 and 2.0.1