Cannot connect to MySQL 4.1+ using old authentication

by

edit: This only applies if you are in control of the MySQL server… if you’re not take a look at Mysql password hashing method old vs new

First check with the SQL query

SHOW VARIABLES LIKE 'old_passwords'

(in the MySQL command line client, HeidiSQL or whatever front end you like) whether the server is set to use the old password schema by default. If this returns old_passwords,Off you just happen to have old password entries in the user table. The MySQL server will use the old authentication routine for these accounts. You can simply set a new password for the account and the new routine will be used.

You can check which routine will be used by taking a look at the mysql.user table (with an account that has access to that table)

SELECT `User`, `Host`, Length(`Password`) FROM mysql.user

This will return 16 for accounts with old passwords and 41 for accounts with new passwords (and 0 for accounts with no password at all, you might want to take care of those as well).
Either use the user management tools of the MySQL front end (if there are any) or

SET PASSWORD FOR 'User'@'Host'=PASSWORD('yourpassword');
FLUSH Privileges;

(replace User and Host with the values you got from the previous query.) Then check the length of the password again. It should be 41 now and your client (e.g. mysqlnd) should be able to connect to the server.

see also the MySQL documentation:
* http://dev.mysql.com/doc/refman/5.0/en/old-client.html
* http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
* http://dev.mysql.com/doc/refman/5.0/en/set-password.html

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. Undefined index $_POST
  3. MySQL connection not working: 2002 No such file or directory
  4. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  5. MySQL Error “Too many connections”
  6. ini_set, set_time_limit, (max_execution_time) – not working
  7. PHP – Secure member-only pages with a login system
  8. Password_Hash not working on my PHP login
  9. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  10. php connection pooling mysql [duplicate]
  11. What to put in database columns when creating registration/login system? (xampp)
  12. How to properly set up a PDO connection
  13. Query with multiple values in a column
  14. Search with comma-separated value mysql
  15. HTTP authentication logout via PHP
  16. How to do this in Laravel, subquery where in
  17. How can I loop through a MySQL result set more than once using the mysql_* functions?
  18. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  19. How to write a REST API?
  20. How do I loop through a MySQL query via PDO in PHP?
  21. Why I can not login to magento backend using google chrome
  22. Getting time difference between two times in PHP [duplicate]
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Is there a way to show a WHERE clause just for one field in MySQL?
  25. PHP best practices for user authentication and password security
  26. Finding free blocks of time in mysql and php?
  27. PHP prepared statements and transactions in a loop [duplicate]
  28. using mysql_close()
  29. Using PDO Prepared Statement and Incrementing a column value
  30. Displaying BLOB image from Mysql database into dynamic div in html

Leave a Comment