Error establishing a database connection

  • I have published my wordpress blog at https://www.bddotnet.com domain.

    After install wordpress it shows an error ‘Error establishing a database connection’ when I try to access my website.

    I also tried to repair like – https://www.bddotnet.com/wp-admin/install.php

    It shows a message like – One or more database tables are unavailable. The database may need to be repaired.

    After repair database it shows the following message –
    The wp_users table is not okay. It is reporting the following error: Table ‘mywp.wp_users’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_users table. Error: Table ‘mywp.wp_users’ doesn’t exist

    The wp_usermeta table is not okay. It is reporting the following error: Table ‘mywp.wp_usermeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: Table ‘mywp.wp_usermeta’ doesn’t exist

    The wp_posts table is not okay. It is reporting the following error: Table ‘mywp.wp_posts’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table ‘mywp.wp_posts’ doesn’t exist

    The wp_comments table is okay.

    The wp_links table is okay.

    The wp_options table is okay.

    The wp_postmeta table is okay.

    The wp_terms table is okay.

    The wp_term_taxonomy table is okay.

    The wp_term_relationships table is okay.

    The wp_commentmeta table is okay.

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
    wp_users: Table ‘mywp.wp_users’ doesn’t exist
    wp_usermeta: Table ‘mywp.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘mywp.wp_posts’ doesn’t exist

    Thanks
    Surajit

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

  • drop all of the tables with phpmyadmin and install again

    I had the same problem. Try this :

    .htaccess :

    php 1
    # BEGIN WordPress
    ErrorDocument 404 /index.php
    # END WordPress

    I had been running XAMPP as a local server to test my WP Theme locally. Everything worked fine until I installed PHP to use with Expression Web3 and preview PHP pages. (I selected “Do not setup a webserver”)during installation. After the installation, PHP pages preview as blank pages within Expression Web3 and samething happened when I started XAMPP. I uninstalled XAMPP, WordPress and PHP. I reinstalled XAMPP and created a Database as usual. Modified the “wp-config” file to reference the Database name and username but when I type “https://localhost/wordpress/wp-admin/install.php” on the address bar to install WP, I get the following: “Error establishing a database connection”. Any ideas? Thanks – Luis

    Moderator t-p

    (@t-p)

    also,

    -Double check your wp-config.php file settings for the database name, and the host name (e.g., “localhost” vs. something else, etc.).

    -access your WordPress database via phpMyAdmin and manually check, in the wp_options table, the siteurl and home values and make sure they are correct.

    CoderJosh

    (@coderjosh)

    As some tables are reported to be okay and some are not, it’s most likely that there’s really a problem with the database, not just with the configuration. The OP should investigate this using phpMyAdmin.

    Phil Marnell

    (@entrepreblog)

    I will cross-post this, as it may apply more than one item, but after pulling my hair out on this for many, many days I got level 2 support at cari.net involved. They were also puzzled, but finally the support person tried something simple: he renamed the folder (‘wordpress’) to ‘wordpressblog’.

    And it instantly began working as advertised.

    Why? Who knows, and at this point I don’t really care to spend anymore time figuring it out.

    But it might be worth a try.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error establishing a database connection’ is closed to new replies.