can’t connect to mysql after migration

  • Resolved marties

    (@marties)


    5 years, 7 months ago

    Using your great plugin, and running last versions : wp 5.1.1, duplicator 1.3.10 and php 7.2.17.

    i get the mysql server error at step 4 (log to admin), after a quick check of wp-config.php i noticed a double quote (instead of a single quote) encapsulating the mysql user’s password value.

    define(‘DB_NAME’, ‘XXX’);
    /** Utilisateur de la base de données MySQL. */
    define(‘DB_USER’, ‘XXX’);
    /** Mot de passe de la base de données MySQL. */
    define(‘DB_PASSWORD’, “XXX”);

    after correcting this, error is gone.

    Hope that helps

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi @marties

    Did your password happen to have a single quote in it? If so that might be the reason there would maybe be an issue. We’ll have to double check this issue.

    Thanks

    Thread Starter marties

    (@marties)

    hi,
    nope, in scrambled order these are the special chars i used _$%] other than a to Z.

    Hey @marties

    If you want to submit a support ticket for this issue we can have a closer look at your setup. Please provide a link to this thread when submitting the ticket.

    Thanks~

    Hey @marties

    Thanks for the feedback! If you can give the developer version a try it may have the updates for your issue. The very latest version (1.3.11) can be found by following these instructions:

    – https://github.com/lifeinthegrid/duplicator/archive/master.zip
    – Uninstall your current version and install this one.

    Let me know if this solves your issue~

    Thanks~

    We found that this issue still existed using Duplicator v1.3.14 when the database password contained a dollar sign character ‘$’.

    We were able to identify the problem quickly and fixed it manually in wp-config. Then we did the research and stumbled on this thread. Hopefully this helps anyone else who stumbles on this issue as well

    Thread Starter marties

    (@marties)

    wow!
    you did well, thanks for posting for the community.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘can’t connect to mysql after migration’ is closed to new replies.