List Info

Thread: note 61884 added to function.mysql-connect




note 61884 added to function.mysql-connect
user name
2006-02-14 17:14:20
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
----
Server IP: 64.246.30.37
Probable Submitter: 80.231.146.145 (proxied: 202.61.37.140)
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit        -- http://master.php.net/manage/user-notes.php?action=
edit+61884
Delete: added to the manual -- htt
p://master.php.net/manage/user-notes.php?action=delete+61884
&report=yes&reason=added+to+the+manual
Delete: bad code            -- http://master.
php.net/manage/user-notes.php?action=delete+61884&report
=yes&reason=bad+code
Delete: spam                -- http://master.php.
net/manage/user-notes.php?action=delete+61884&report=yes
&reason=spam
Delete: useless             -- http://master.p
hp.net/manage/user-notes.php?action=delete+61884&report=
yes&reason=useless
Delete: non-english         -- http://mast
er.php.net/manage/user-notes.php?action=delete+61884&rep
ort=yes&reason=non-english
Delete: already in docs     -- http://
master.php.net/manage/user-notes.php?action=delete+61884&
;report=yes&reason=already+in+docs
Delete: other reasons       -- http://master.php.net/manage/user-
notes.php?action=delete+61884&report=yes
Reject      -- http://master.php.net/manage/user-
notes.php?action=reject+61884&report=yes
Search      -- http://ma
ster.php.net/manage/user-notes.php

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

note 61884 deleted from function.mysql-connect by bjori
user name
2006-04-15 18:41:43
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

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )