Search code examples
mysqlvisual-studioentity-frameworkmysql-workbench

MySQL connectivity error unable to retrieve list of database


I am trying to connect visual studio to MySQL and get the following error.I looked it up online but couldn't find a solution. Here is the picture of error.

Error


Solution

  • [SOLVED]

    Well finally I downloaded the previous version of MySQL which is 5.7.22. After that I downloaded MySQL.Data and MySQL DLLs from nuGet then connected visual studio 2017 with MySQL then it established a successful connection.

    Before installing previous version of MySQL you must uninstall currently installed MySQL. Hope it helps someone who is facing the same issue.