Re: Connection Error - .NET Connector
Posted by: JOSE RAMIREZ
Date: September 26, 2018 10:07AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Connection Error - .NET Connector
September 26, 2018 10:07AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.