Re: Connection Error - .NET Connector

[JOSE RAMIREZ]

Hello Nicholas,

the error you are describing is usually returned whenever the password provided in the connection string is incorrect. Are you able to successfully connect with a different user or with a different tool such as the mysql client included in the server using the same user and password?

"mysql_native_password" is one of the authentication plugins/methods used to authenticate to MySQL. Based on the authentication plugin being used the security and way of authentication will vary (see more info at: https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html). "mysql_native_password" is the default authentication plugin in server versions lower than 8.0. You can specify the authentication plugin to associate to a user whenever creating it with the "CREATE USER" command, Connector/NET will attempt to authenticate using the user's assigned authentication plugin.

"Integrated Security" is a connection option specific to Windows environments where the Windows authentication plugin is used for authentication. The option is supported only for commercial versions of Connector/NET which is why it is set to "false" by default. This shouldn't be the issue since your user appears to be associated to "mysql_native_password". To validate that you can query the "user" table in the "mysql" database.


Regards,
Jose Ramirez.