Go the configuration file of MySQL, usually called “my.ini
” in Windows.
At the section of [mysqld
] add the following line:
default_authentication_plugin = mysql_native_password
Restart MySQL server.
Another alternative solution is by upgrading the Connector/NET (mysql.data.DLL).