“Error establishing a database connection” while updating plugin

  • Resolved dreq72

    (@dreq72)


    4 years, 3 months ago

    So I was updating the plugins of my site and “WP phpMyAdmin” was the last plugin being updated. It was taking a long time so I decided to leave it alone, let it do its job and come back later to the page.

    So I come back after an hour and its still stuck on the updating message. I visit the homepage and now I get a “Error establishing a database connection” message.

    So I think maybe it’s still updating and leave it for another hour or so.

    I come back and it’s still the same. I check the actual PHPMyadmin page and get this:

    ———————————-
    phpMyAdmin – Error
    Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.

    session_start(): open(SESSION_FILE, O_RDWR) failed: Read-only file system (30)

    session_start(): Failed to read session data: files (path: /var/lib/php/sessions)
    ———————————-

    So I login to my server and find out I can’t access MySQL at all. MySQL has become read only.

    I hope someone can help. Also, any ideas why this happened?

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author ttodua

    (@ttodua)

    Hi.
    If you read the “Readme” page of this plugin, it says that once in a while people might experience quite weird issue, and this should be tested by the developer of a website. Even our plugin changelogs tell that there was no practical change during last versions (for which you were updating).
    I am just a maintainer of this plugin (and not PhpMyAdmin). What I can say is that this WP plugin has no relation to database, it doesn’t even fire a single DB query. It even doesn’t call PhpMyAdmin functions (unless you enter PhpMyAdmin page from WordPress dashboard).

    Just to add 2 cents, you might need to contact the server administrator and ask to restart mysql instance. in case of VPS (linux,ubuntu, etc..) i might have tried restarting services:
    systemctl restart mysql (or mysqld)
    and (whichever used):
    systemctl restart apache2
    systemctl restart nginx

    if the issue will still persist, someone mentions this for specific folder to restore permissions: https://stackoverflow.com/a/9579777/2377343

    however, neither these can be called as my recommendation, instead these are just my thoughts.

    • This reply was modified 4 years, 3 months ago by ttodua.
    • This reply was modified 4 years, 3 months ago by ttodua.
    • This reply was modified 4 years, 3 months ago by ttodua.
    • This reply was modified 4 years, 3 months ago by ttodua.
    • This reply was modified 4 years, 3 months ago by ttodua.
    Plugin Author ttodua

    (@ttodua)

    lastly, i advise not to keep plugin active when you dont use , and only activate it before using. So, you will be confident.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘“Error establishing a database connection” while updating plugin’ is closed to new replies.