WordPress Install Issues

WordPress has a built-in way to attempt to repair your database, but you’ll have to enable this feature first. To do so, you’ll need to access your wp-config.php file, which contains your WordPress installation settings and configuration.
You can find wp-config in your root WordPress file directory. You can access it by logging into your cPanel, selecting File Manager, and navigating to the folder where you installed WordPress.Once you have wp-config open, add this line of code to the bottom:
define( ‘WP_ALLOW_REPAIR’, true );
This line will enable you to optimize and repair your database by navigating to https://www.yourwebsite.com/wp-admin/maint/repair.php (just replace “yourwebsite.com” with your actual URL). You should see the above screen with two options to repair, or repair and optimize your database. Feel free to choose either; just note that optimizing will take longer.

Sharvin, Unfortunately that didn’t work. That maybe because this is a fresh install and the tables don’t exist yet. The suggestion you gave now gives me the following error when I goto the repair.php page…

WordPress database error Table ‘wp_database.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’ LIMIT 1 made by require_once…. (VERY LONG)

As the above step didn’t work or didn’t apply to you, then the next thing you can do is take a look at your database settings in your wp-config file.You’ll see the login credentials for your database, probably near the top of the file. It should look something like this:

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘database_name_here’ );

/** MySQL database username */
define( ‘DB_USER’, ‘username_here’ );

/** MySQL database password */
define( ‘DB_PASSWORD’, ‘password_here’ );

/** MySQL hostname */
define( ‘DB_HOST’, ‘localhost’ );

If anyone of these values is incorrect, WordPress will not be able to connect to the database.One way to check your database outside of WordPress is by using PHPMyAdmin, a tool for accessing and editing MySQL databases. PHPMyAdmin is included with most hosting plans, and you can find it in your cPanel dashboard.
Just be very careful using PHPMyAdmin, since you’ll be dealing directly with your site’s database. Once you’ve logged in to PHPMyAdmin, you will see a list of databases on your server in the left-hand column. Click on the one that matches the name in your wp-config file (it will be the value after DB_NAME, where it says “database_name_here” in the above sample code).Don’t see any databases? Contact your hosting company, since the entire problem may be an issue with your server.

You can also try out this options:
Option 1: Test your existing credentials.
Create a file in your WordPress directory called something like testconnection.php (the name doesn’t matter; just the .php extension). Paste the following code:
<?php
$test Connection = mysql_connect(‘localhost’, ‘root’, ‘password’);
if (!$testConnection) {
die(‘Error: ‘ . mysql_error());
}
echo ‘Database connection working!’;
mysql_close($testConnection);
?>
Once you’ve created that file, just navigate to the URL of the file in your browser (e.g. your site.com/testconnection.php). You’ll see either a successful connection message, or an error with more details.
If the username and password aren’t working, you can just create a new one.

Option 2: Create a new database user and password.
We can do that using a different tool available in cPanel called “MySQL? Databases.” Go ahead and click on that, then scroll down to the heading: MySQL Users: Add New User.” Choose a username and strong password, and make note of them for your wp-config file. Click “Create User.” Now scroll down to the heading “Add User To Database,” and choose your new username and your WordPress database, and click “Add.” Update your wp-config file with the new username and password.
Now your database name, username, and password are all correct. That just leaves DB_HOST.
In most cases, this value will be “localhost,” but it depends on your host’s settings. WordPress has a list of common hosts with their DB_HOST values on their website. If your host isn’t listed there, you can contact your hosting company to ask what value to use.

3. Still getting the error message? Check with your hosting company
If you’ve followed the above troubleshooting steps and your website is still down, it could be a problem on your host’s end. Contact your web hosting company’s support and give them all the details of the error and the troubleshooting actions you’ve taken, and they may be able to help you determine the cause of the error.
Good Luck! I hope this helps you

Sharvin,

So, I have checked the wp-config file as you have stated multiple times. Login, passwords, db and host are all correct.

As for the other steps I have done Option 1 (as stated in my original post) and it works and connects. I have tried Option 2 (Multiple times recreated users – reinstalled everything thinking something may have corrupted) and it doesn’t work. As a reminder I am on windows and do not use linux, so cPanel isn’t an option. I do use MySQL’s Workbench. I have recreated the database, created a separate user with full right permissions (Even used root), used localhost and the ip address. still nothing. And as for Option 3 we don’t use a hosting company this is on my own server.

Hence my frustration. Shouldn’t be so difficult.

Sharvin,

I probably should also address that the Option 1 script I had to modify to use mysqli instead, this is due to newer versions of PHP don’t have or use the old mysql plugin anymore. WordPress recommends the version of PHP I am using and supports mysqli from what I could find in the source wp-db.php

I am not sure this will work but you can try if this command works
UPDATE wp_options SET option_value=’YOUR_SITE_URL’ WHERE option_name=’siteurl’
For Some People this method as work.

You might also check this link it may help you
Topic: Error Establishing a Database Connection

• This reply was modified 6 years, 7 months ago by Sharvin Shah.
• This reply was modified 6 years, 7 months ago by Sharvin Shah.

Sharvin,

Well the problem is the tables don’t exist. The install, I am assuming should create them at some point. But isn’t doing so. The database is there and can connect to it.. just no tables are being created by WP on install or something. I feel a step is missing.