Re: MySQL Password() & PHP encryption?
| From: | John W. Holmes | Date: | Fri, 07 May 2004 02:07:16 +0000 |
| Subject: | Re: MySQL Password() & PHP encryption? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34295@lists.php.net to get a copy of this message | ||
Theisen, Gary wrote:
I've recently upgraded my mysql to v 4.1.1 (on win nt 4.0) and set the Passwords in the user table to the mysql Password() function. Now, this doesn't work anymore when call from a php web script (which is a good thing, cause it's plain text): mysql_connect ("localhost", "theID", "thePassord"); gives me this error: Client does not support authentication protocol requested by server ... Since my mysql.mysql user table now has the 41 bit encrypted passwords stored...how to I connect with my php scripts? I've tried md5(), sha1()...but they don't generate the same 41 bit encrypted password. Anyone have a suggestion?You need to use the mysqli extension with MySQL 4.1+ -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com