Authentication with old password no longer supported, use 4.1 style passwords

by

I had the same problem. In my case just ran the command below connected on my database by the Workbench:

SET SESSION old_passwords=0;
SET PASSWORD FOR my_user=PASSWORD('my_password');

After that I could connnect using MySql Connector 6.6.5 in the c# code with the common mysql connection string:

"server=my_server_ip;user=my_user;database=my_db;port=3306;password=my_password;"

More Related Contents:

  1. How do I send generated encrypted password from C# to MySQL
  2. Validate a username and password against Active Directory?
  3. Dependency Injection in attributes
  4. Exception: There is already an open DataReader associated with this Connection which must be closed first
  5. How can I make SMTP authenticated in C#
  6. .NET Core 2.1 Identity get all users with their associated roles
  7. MySqlCommand Command.Parameters.Add is obsolete
  8. LINQ to SQL multiple tables left outer join
  9. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  10. Convert DateTime for MySQL using C#
  11. How to validate domain credentials?
  12. Get the id of inserted row using C#
  13. .NET Core Identity Server 4 Authentication VS Identity Authentication
  14. Custom Authentication in ASP.Net-Core
  15. Unable to connect to any of the specified mysql hosts. C# MySQL
  16. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  17. ASP.NET Core 2.0 disable automatic challenge
  18. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  19. Entity Framework creates a plural table name, but the view expects a singular table name?
  20. Cookie Authentication expiring too soon in ASP.NET Core
  21. Index (zero based) must be greater than or equal to zero
  22. The HTTP request is unauthorized with client authentication scheme ‘Ntlm’ The authentication header received from the server was ‘NTLM’
  23. Simple token based authentication/authorization in asp.net core for Mongodb datastore
  24. cURL with user authentication in C#
  25. Connection to MySQL from .NET using SSH.NET Library
  26. Built-in helper to parse User.Identity.Name into Domain\Username
  27. .NET 4.5 Bug in UserPrincipal.FindByIdentity (System.DirectoryServices.AccountManagement)
  28. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  29. How to authenticate user with Azure Active Directory using OAuth 2.0?
  30. MySQL C# async methods doesn’t work?

Leave a Comment