Connection error--please help!

Discussion in 'MySQL' started by netpox, Mar 5, 2007.

  1. #1
    I am connecting from a page on one server to a database on a different server and got this error:

    FATAL ERROR: Connection to database server failed.Client does not support authentication protocol requested by server; consider upgrading MySQL client

    Anyone know how to fix it?
     
    netpox, Mar 5, 2007 IP
  2. Sini

    Sini Peon

    Messages:
    119
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What do you have in your config file (edit out all private info such as pasword etc before posting it)?
     
    Sini, Mar 5, 2007 IP
  3. netpox

    netpox Active Member

    Messages:
    1,625
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #3
    On my server i just use localhost..but on the other server i cant use localhost because the databse isnt on that server...so i contacted my dedicated server provider and they said just to use server.mydomain.com

    when i did that it said server unknown or something like that then i did just mydomain.com and thats when i got that error message. When i change the password it gives me cannot connect because of the password, when the password is good it gives me that:

    Client does not support authentication protocol requested by server; consider upgrading MySQL client

    so it looks like it did connect but then authentication protocol is not supported...i have no clue what that means.
     
    netpox, Mar 5, 2007 IP
  4. klown

    klown Peon

    Messages:
    2,093
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    0
    #4
    That means the server doesn't accept remote connections. You may need to set this to work inside your cpanel.
     
    klown, Mar 5, 2007 IP
  5. vishwaa

    vishwaa Well-Known Member

    Messages:
    271
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    138
    #5
    vishwaa, Mar 6, 2007 IP
  6. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #6
    The server that contains mysql needs to be configured to allow remote access.
    If you have cPanel control panel, you can do this in the MySQL section
     
    cyanide, Mar 6, 2007 IP
  7. netpox

    netpox Active Member

    Messages:
    1,625
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #7
    I've done that and still the same problem.
     
    netpox, Mar 7, 2007 IP
  8. Mystique

    Mystique Well-Known Member

    Messages:
    2,579
    Likes Received:
    94
    Best Answers:
    2
    Trophy Points:
    195
    #8
    Even setting your connection via cpanel, some hosting providers disallow remote connections from the server configuration so you will not succeed if it's set this way.

    In my experience the only shared hosting that supports this is Netfirms, from which panel you can allow or deny such connection.
     
    Mystique, Mar 7, 2007 IP
  9. spachev

    spachev Peon

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    The authentication protocol was changed in 4.1. Probably the easiest ( and possibly the only if you are not an admin on the server) solution is to upgrade your client to 4.1 or newer.
     
    spachev, Mar 8, 2007 IP
  10. Sini

    Sini Peon

    Messages:
    119
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #10
    You will have to upgrade your mysql client or change your mysql password mode to oldpasswords...On command line run the following:

    1. mysql -u root -p

    next you will have to enter your mysql root password next

    mysql> UPDATE mysql.user SET password=OLD_PASSWORD('your_password') WHERE user='your_mysql_username' AND host='host'; (hit return)
     
    Sini, Mar 8, 2007 IP