MySQL PHP incompatibility

by

The MySQL account you’re using probably has an old 16 character long password (hash).
You can test that with a MySQL client (like HeidiSQL, the MySQL console client or any other client) and an account that has access to the mysql.user table. If the Password field contains 16 chars it’s an old password and mysqlnd cannot use it to connect to the MySQL server.
You can set a new password for that user with

SET PASSWORD FOR 'username'@'hostmask' = PASSWORD('thepassword')

see dev_mysql_set_password

edit:
You should also check if the server is set to use/create old passwords by default.

edit2:
Please run the query

SELECT
  Length(`Password`),
  Substring(`Password`, 1, 1)
FROM
  `mysql`.`user`
WHERE
  `user`='username'

on the 5.0.22 server (the one that’s “failing”). Replace username by the account you’re using in mysql_connect().
What does that return?

More Related Contents:

  1. How to insert images into a database using PHP [closed]
  2. How to change mysql to mysqli?
  3. php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
  4. How do I use password hashing with PDO to make my code more secure? [closed]
  5. MySQLi prepared statements error reporting [duplicate]
  6. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  7. PHP Fatal error: Class ‘PDO’ not found
  8. Connect to a MySQL server over SSH in PHP
  9. How to store NULL values in datetime fields in MySQL?
  10. PHP Warning: mysqli_connect(): (HY000/2002): Connection refused
  11. Javascript function post and call php script
  12. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  13. Trying to access array offset on value of type bool
  14. Fatal error: Call to a member function query() on null
  15. How to insert json array into mysql database
  16. PHP PDO how to run a multiple query request?
  17. Using utf8mb4 with php and mysql
  18. how do I get month from date in mysql
  19. mysql_connect VS mysql_pconnect [closed]
  20. How do I save PHP session data to a database instead of in the file system?
  21. Strange problem with the length of the field gotten from database [duplicate]
  22. Difference between mysql_fetch_array and mysql_fetch_row?
  23. MySQL, how to insert null dates
  24. Can I detect and handle MySQL Warnings with PHP?
  25. Escaping SQL queries in Codeigniter
  26. mysql_fetch_array skipping first row
  27. 500 Internal Server Error?
  28. How to write a stored procedure in phpMyAdmin?
  29. Aggregated query without GROUP BY
  30. mysql count into PHP variable

Leave a Comment