note 47226 deleted from function.mysql-connect by aidan
| From: | aidan@php.net | Date: | Mon, 08 Nov 2004 04:17:26 +0000 |
| Subject: | note 47226 deleted from function.mysql-connect by aidan | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-80262@lists.php.net to get a copy of this message | ||
Note Submitter: jurgen at person dot be
----
The password hashing mechanism was updated in MySQL 4.1 and higher versions to provide better
security and to
reduce the risk of passwords being intercepted. Using the above mysql_connect() example, You can get
an error when You connect :
"Client does not support authentication protocol requested
by server; consider upgrading MySQL client"
This error occurs using PHP 5 - Mysql 5 too.
You can solve this to create SHORT HASHES for Your passwords inside Your Mysql tables:
# Connect to Mysql with mysql cli:
#use mysql
#SET PASSWORD FOR user = OLD_PASSWORD('your_password');
#SET PASSWORD FOR user@localhost = OLD_PASSWORD('your_password');
#flush privileges;
reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
----
Reason: useless note