Error establishing a database connection

java2guide
(@java2guide)

16 years, 2 months ago

I have published my wordpress blog at http://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 – http://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)

Samuel B
(@samboll)

16 years, 2 months ago

drop all of the tables with phpmyadmin and install again

wernerb
(@wernerb)

16 years, 2 months ago

I had the same problem. Try this :

.htaccess :

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

Luis
(@iaguilui)

16 years, 2 months ago

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 “http://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)

15 years, 6 months ago

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)

15 years, 6 months ago

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)

15 years, 6 months ago

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.