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