note 47226 deleted from function.mysql-connect by aidan

From: 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

« previous php.notes (#80262) next »