warning message

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Fang

    warning message

    Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an existing
    database, it showed me the following warning message which I have no idea how to
    solve it. Hope someone can kindly tell me what I should do. Thanks in advance.


    Warning: mysql_connect() : Client does not support authentication protocol
    requested by server; consider upgrading MySQL client in
    c:\inetpub\wwwr oot\project\con nection.php on line 12
    Could not connect: Client does not support authentication protocol requested by
    server; consider upgrading MySQL client


  • Andy Hassall

    #2
    Re: warning message

    On Mon, 2 May 2005 06:41:12 +0000 (UTC), " Fang" <s4041650@stude nt.uq.edu.au>
    wrote:
    [color=blue]
    >Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an existing
    >database, it showed me the following warning message which I have no idea how to
    >solve it. Hope someone can kindly tell me what I should do. Thanks in advance.
    >
    >Warning: mysql_connect() : Client does not support authentication protocol
    >requested by server; consider upgrading MySQL client in
    >c:\inetpub\www root\project\co nnection.php on line 12
    >Could not connect: Client does not support authentication protocol requested by
    >server; consider upgrading MySQL client[/color]

    Search on Google. The first hit for this error message is the explanation from
    the MySQL manual. (Most of the other hits are people explaining this).

    --
    Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
    <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

    Comment

    • coolsti

      #3
      Re: warning message

      On Mon, 02 May 2005 06:41:12 +0000, Fang wrote:
      [color=blue]
      > Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an
      > existing database, it showed me the following warning message which I
      > have no idea how to solve it. Hope someone can kindly tell me what I
      > should do. Thanks in advance.
      >
      >
      > Warning: mysql_connect() : Client does not support authentication
      > protocol requested by server; consider upgrading MySQL client in
      > c:\inetpub\wwwr oot\project\con nection.php on line 12 Could not connect:
      > Client does not support authentication protocol requested by server;
      > consider upgrading MySQL client[/color]

      Hi,

      I am sure the former reply with the google search says it all. But in case
      you want a short explanation in the clear, it is because the newer mysql
      versions use a stronger encryption than the older. But the functions
      within PHP still are based on the older. So there is a mismatch here. You
      won't be able to authenticate as the passwords won't seem to match, even
      though the unencrypted versions are the same.

      For now, to get around this, you request your mysql to use old passwords.
      I am sure the Google search tells you how to do this exactly. If you look
      at "show variables" in a mysql terminal, and see "old_passwo rds = on" or
      whatever it is exactly, you should be ok. If off, you get the error you
      are experiencing.

      Comment

      Working...