note 61884 deleted from function.mysql-connect by bjori
| From: | bjori@php.net | Date: | Sat, 15 Apr 2006 18:41:43 +0000 |
| Subject: | note 61884 deleted from function.mysql-connect by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-108197@lists.php.net to get a copy of this message | ||
Note Submitter: imranbiz at gmail dot com
----
If got this kind of error "mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client"
Its due to version issue. Just use mysql query browser, login with root and update the user table in
mysql database.
SELECT * FROM user
copy password from the row of the specific user you want to modify.
e.g *23AE809DDACAF96AF0FD78ED04B6A265E05AA257
then just use update query
update user set Password='imransidat' where
password='*23AE809DDACAF96AF0FD78ED04B6A265E05AA257'
Its simple. And time saving too. Best of luck