MySQL remote connection fails with “unknown authentication method”

by

Assuming you’re using PHP 5.3+, you could be experiencing one of the Backward Incompatibility Changes:

The new mysqlnd library necessitates the use of MySQL 4.1’s newer 41-byte password format. Continued use of the old 16-byte passwords will cause mysql_connect() and similar functions to emit the error, “mysqlnd cannot connect to MySQL 4.1+ using old authentication.”

If so, see https://stackoverflow.com/a/1340538/187954 for information on updating your password.

More Related Contents:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  3. Mysql adding user for remote access
  4. MySQL versus PDO [duplicate]
  5. phpMyAdmin on MySQL 8.0 [duplicate]
  6. How to increase MySQL connections(max_connections)?
  7. Remote connect to clearDB heroku database
  8. MySQL – Persistent connection vs connection pooling
  9. php, mysql – Too many connections to database error
  10. Could not connect: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  11. Access mysql running on localhost from minikube
  12. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  13. Sequel Pro and MySQL connection failed
  14. how to delete data from table A besides the customer service and director data in table B?
  15. Get records with max value for each group of grouped SQL results
  16. How to store multiple options in a single table?
  17. Get the new record primary key ID from MySQL insert query?
  18. MySQL: multiple tables or one table with many columns? [closed]
  19. Add 2 hours to current time in MySQL?
  20. MySQL trigger On Insert/Update events
  21. MySQL combine two columns into one column
  22. How to get first day of every corresponding month in mysql?
  23. My MySQL trigger doesn’t work, simple syntax, not complicated
  24. How can VBA connect to MySQL database in Excel?
  25. Select a column with a keyword name
  26. Sum results of a few queries and then find top 5 in SQL
  27. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  28. Use Composite Primary Key as Foreign Key
  29. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  30. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?

Leave a Comment