cannot connect to MySQL 4.1 using the old insecure authentication

  • Resolved timmitra

    (@timmitra)


    10 years, 1 month ago

    I’ve been hired to migrate the site from Joomla to wordpress. It looks like they are using a newer method to log onto he mysql server?

    [fgj2wp] Couldn’t connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.
    SQLSTATE[HY000] [2000] 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. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

    Please advise

    https://www.ads-software.com/plugins/fg-joomla-to-wordpress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Kerfred

    (@kerfred)

    It is a MySQL error saying that the used version of MySQL is too old.
    You can reset the password as asked.
    Another solution is to copy the Joomla database to your WordPress host and use the WordPress credentials in the plugin settings.

    Thread Starter timmitra

    (@timmitra)

    That is really odd, since this a current version of joomla and the database was only created 6 months ago. I can log in to the database with PMA using the same credentials.

    Thread Starter timmitra

    (@timmitra)

    Thanks. Loading from my local server worked.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘cannot connect to MySQL 4.1 using the old insecure authentication’ is closed to new replies.