Professional Web Applications Themes

can't logon to db with mysql client: mysql 5 passwords - MySQL

I recently have had some difficulty getting my mysql client to logon to my remote dbs and I'm thinking it may be that my host service has shifted to mysql 5.x from 4.x. I know there is a password validation difference. Can anyone clarify and suggest a remedy....

  1. #1

    Default can't logon to db with mysql client: mysql 5 passwords


    I recently have had some difficulty getting my mysql client to logon to my
    remote dbs and I'm thinking it may be that my host service has shifted to
    mysql 5.x from 4.x. I know there is a password validation difference.
    Can anyone clarify and suggest a remedy.


    rog Guest

  2. #2

    Default Re: can't logon to db with mysql client: mysql 5 passwords

    On 2006-04-28, rog <jk!ttop5mnpX$.net> wrote:
    > I recently have had some difficulty getting my mysql client to logon
    > to my remote dbs and I'm thinking it may be that my host service has
    > shifted to mysql 5.x from 4.x. I know there is a password validation
    > difference. Can anyone clarify and suggest a remedy.
    If you're getting a 'Client does not support authentication protocol
    requested by server; consider upgrading MySQL client' message, then your
    suspicion is indeed right, see:
    [url]http://dev.mysql.com/doc/refman/5.0/en/old-client.html[/url]

    --
    Riemer Palstra Amsterdam, The Netherlands
    [email]riemerpalstra.com[/email] [url]http://www.palstra.com/[/url]
    Riemer Palstra Guest

  3. #3

    Default Re: can't logon to db with mysql client: mysql 5 passwords

    Thanks, that's what I was looking for...



    "Riemer Palstra" <riemerpalstra.com> wrote in message
    news:slrne546mn.lsg.riemerpalstra.com...
    > On 2006-04-28, rog <jk!ttop5mnpX$.net> wrote:
    >> I recently have had some difficulty getting my mysql client to logon
    >> to my remote dbs and I'm thinking it may be that my host service has
    >> shifted to mysql 5.x from 4.x. I know there is a password validation
    >> difference. Can anyone clarify and suggest a remedy.
    >
    > If you're getting a 'Client does not support authentication protocol
    > requested by server; consider upgrading MySQL client' message, then your
    > suspicion is indeed right, see:
    > [url]http://dev.mysql.com/doc/refman/5.0/en/old-client.html[/url]
    >
    > --
    > Riemer Palstra Amsterdam, The Netherlands
    > [email]riemerpalstra.com[/email] [url]http://www.palstra.com/[/url]

    rog Guest

Similar Threads

  1. Replies: 2
    Last Post: February 14th, 10:54 AM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. max_allowed_packet from MySQL to php-client
    By Ville Ahonen in forum PHP Development
    Replies: 2
    Last Post: August 23rd, 09:11 PM
  4. Replies: 0
    Last Post: September 10th, 12:02 AM
  5. Replies: 0
    Last Post: September 10th, 12:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139