CODEWITHSUNDEEP
mysqlasp.netentity-framework
Sounouk
Sounouk

Reputation: 95

Entity Framework & Reverse Engineer Code First & MySQL: error access denied

I'm trying to use Entity Framework Reverse Engineer Code First with MySQL DB, I have installed these: mysql-for-visualstudio-1.2.3 & mysql-connector-net-6.9.3

The connection to MySQL DB seems to work: enter image description here

I get the following error:

System.Data.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> MySql.Data.MySqlClient.MySqlException: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: NO) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'root'@'localhost' (using password: NO)

I tried a lot of solutions found on the internet but nothing works.

Here is the connection string I have in the web.config: 

   <add name="TFEContext" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;
  port=3306;database=tfe_schema;uid=root;password=********"/>

Upvotes: 0

Views: 1575

Answers (1)

Sounouk
Sounouk

Reputation: 95

After 2 days of search, I checked the box "Save my password" and it's working but the password to access the MySQL server is hardcoded in the web.config. enter image description here

Upvotes: 1

Related Questions