Able to access website but not wp-admin

  • sunjerry019

    (@sunjerry019)


    4 years, 5 months ago

    I just migrated my WordPress installation from one server to another. When I go to /wp-admin/, it says that I need to upgrade the database, which I do. When I press continue, it says

    Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /var/www/html/wp-includes/wp-db.php on line 1653

    No such file or directory

    This tells me that previously, it could connect to the mysql database, and subsequently not any more? I can access the main website just fine, so it seems that only wp-admin is having issues connecting.

    I have tried to change DB_HOST from localhost to 127.0.0.1, but then it reports Connection Refused, which I guess is a result of using mysql_secure_installation?

    mysqli.default_socket = /var/run/mysqld/mysqld.sock is set in my PHP-FPM configuration file, so it should know where to find the MySQL socket.

    I am very perplexed and would appreciate any help or advice! Thanks in advance!

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    Try downloading WordPress again, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel (consult your hosting provider’s documentation for specifics on these), and delete then replace your copies of everything on the server except the wp-config.php file and the /wp-content/ directory with fresh copies from the download. This will effectively replace all of your core files without damaging your content and settings.

    Some uploaders tend to be unreliable when overwriting files, so don’t forget to delete the original files before replacing them.

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    Thank you very much for the suggestion! Unfortunately, after downloading and replacing the files, it goes through the same screens again (Update Database > Error No such file or directory).

    Could there be some other reason behind this?

    Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    Hm, is this a local install?

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    Yes, this is a local install of a WordPress instance on an Ubuntu 18.04 Droplet.

    Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    Ah, ok. Please repost at https://wordpress.org/support/forum/localhost-installs/#new-topic-0

    Local installs, and local servers in general, are a very specialized field, and the people who can help regularly watch that forum.

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    Okay thanks!

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    I realized I might have misunderstood you. The wordpress instance is running off an internet facing Ubuntu 18.04 Droplet with a FQDN. It is not exactly a localhost install.

    If it is somehow relevant, it also has SSL through LetEencrypt.

    • This reply was modified 4 years, 5 months ago by sunjerry019.
    Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    Hm, it does sound like something may be configured on the server configuration.

    Perhaps MySQL not properly installed.

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    If it is not properly installed, I don’t understand why the initial connection worked (“Need to upgrade database”) but not any subsequent ones. Furthermore, the main webpage loads just fine.

    I’m not sure if its relevant, but I migrated the site from an Ubuntu 14.04 to an 20.04 Droplet. Would there be some hidden incompatible features between the MySQL versions that would manifest in an exported .sql file?

    • This reply was modified 4 years, 5 months ago by sunjerry019.
    Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    Which version of MySQL are you running now?

    Thread Starter sunjerry019

    (@sunjerry019)

    4 years, 5 months ago

    I am currently running MySQL Ver 8.0.27. And I made a mistake, the droplet is now running 20.04 instead of the previously mentioned 18.04.

    Moderator James Huff

    (@macmanx)

    4 years, 5 months ago

    That MySQL version should be fine. Do you have this issue under different versioned droplets?

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

The topic ‘Able to access website but not wp-admin’ is closed to new replies.