Remote error: mysqlnd cannot connect to MySQL 4.1+ using old authentication

Discussion in 'HTML / PHP / JavaScript / CSS' started by gardavis, Feb 1, 2011.

  1. gardavis

    gardavis

    I am not really a PHP developer but am working with a client who has a PHP site connected to MySQL on DASP. It is running fine.

    I am setting up a developement environment on my local server and installed the current PHP to my Windows 7 IIS 7.5 and the site runs except that it cannot connect to the remote MySQL:

    mysqlnd cannot connect to MySQL 4.1+ using old authentication...

    It appears to be some mismatch with the password length. It appears old_passwords=1 is set on the MySQL 4.1 on DASP.

    So my question is....why does the site work fine on the server but my environment does not? Is my PHP set up differntly than the DASP PHP?

    Thanks,
    Gary Davis
    [email protected]
     
    gardavis, Feb 1, 2011
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    The default MySQL port 3306 is probably blocked on your network. To verify if this is true or not, please try to run the following command in your command prompt:

    telnet mysql501.discountasp.net 3306

    If the connection cannot be established, you will receive something like

    "Connecting To mysql501.discountasp.net ...Could not open connection to the host, on port 3306: Connect failed"

    Try to disable temporarily your antivirus/firewalls to see if they are blocking this port.
     
    dmitri, Feb 1, 2011
    #2
  3. gardavis

    gardavis

    Actually, I can connect from my desktop if I use a MySQL manager tool and it lets me run queries, etc.

    The tool does not use PHP, of course, so the restriction seems to be my PHP implementation or settings.

    Thanks,
    Gary
     
    gardavis, Feb 1, 2011
    #3
  4. gardavis

    gardavis

    Solution

    I posted the problem on http://www.experts-exchange.com and got the solution - DASP is running PHP version 5.2.6 and I was running 5.3.5. I uninstalled my PHP, downloaded the current 5.2 version (5.2.17) and it worked. I can now connect to the database just fine.

    Thanks,
    Gary Davis
    Webguild.com
     
    gardavis, Feb 6, 2011
    #4
  5. mjp

    mjp

    Thanks for posting that follow up.
     
    mjp, Feb 7, 2011
    #5

Share This Page