mysql remote connection

  • Resolved bhavlice

    (@bhavlice)


    15 years ago

    When trying to login to a remote Mysql database server, I get the following error:

    mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user.

    Some have said to regress to an earlier version of mysql which is TOTALLY unacceptable. Is there some way to make the current password compatable with the 4.1 version?
    I need a walkthrough of the SET PASSWORD idea.

    Please help as this is critical for my plugin.
    Bill

The topic ‘mysql remote connection’ is closed to new replies.