Unable to connecte to the database…

  • Resolved jubilo

    (@jubilo)


    10 months ago

    Hi I get this error after migrating my site from one server to another with Duplicator Pro.
    I am using a server with Plesk running.

    I have tried everything in this guide: https://kb.mailpoet.com/article/200-solving-database-connection-issues

    Step 1: Find the line define(‘DB_HOST’, ‘localhost’); and replace it with define(‘DB_HOST’, ‘127.0.0.1’);

    Does not work

    Step 2: Edit yourphp.ini file and properly set the value for pdo_mysql.default_sock

    Does not work

    Step 3:

    Delete all database tables starting with “Mailpoet”.

    Does not work

    I installed another generic wordpres site on the same server and Mailpoet works.

    Please help me.

    • This topic was modified 10 months ago by jubilo.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter jubilo

    (@jubilo)

    Any solution?
    Maybe some configuration passed through the database?

    Thread Starter jubilo

    (@jubilo)

    Solved by ourselves.

    If someone has this error, after a migration from one server to another.
    Check wp-config.php

    In my case the database was listed as: utf8mb3
    When I changed it to the correct one: utf8
    (it should be noted that they are compatible but utf8mb3 allows less characters than utf8)

    Mailpoet started working again.

    Plugin Support Sean O))) a11n

    (@seanomattic)

    Hey @jubilo,

    That’s great. Thanks a lot for sharing your discovery with us! We’ll test it out and verify that it works. If so, we can add it to the documentation.

    All the best!

    I am having the same issue, but I am running on Azure. the UTF8 solution did not work for me. Are there any other alternatives.

    My /** MySQL hostname */

    define(‘DB_HOST’, $connectstr_dbhost);

    I don’t have localhost. any suggestions

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    Hi there, @tamss13 !

    Can you confirm if you have tried all the suggestions in this guide?

    Yes. I had to turn off transport security and it started to work.

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    That’s great to hear! Thanks for letting us know @ntxice . I’m closing this topic then. Cheers!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Unable to connecte to the database…’ is closed to new replies.