Title: Database Error: wp_options doesn’t exist
Last modified: August 19, 2016

---

# Database Error: wp_options doesn’t exist

 *  Resolved [dhbarr](https://wordpress.org/support/users/dhbarr/)
 * (@dhbarr)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/database-error-wp_options-doesnt-exist/)
 * **The Setup**
    - WordPress 2.3
    - PHP 5.2.5 (win32)
    - FastCGI for IIS6.0 (win32)
    - MySQL 5.0.45 (win32)
    - IIS6 (win32)
    - Win 2k3 Server, Ent. 32-bit
 * IIS6 and MySQL are on two different machines.
    Have confirmed database connectivity
   between IIS6 and MySQL …via command-line logon …using MySQL credentials …assigned
   to WordPress.
 * **The Config**
 *     ```
       define('DB_NAME', '**database**');
       ```
   
 * define(‘DB_USER’, ‘**username**’);
 *     ```
       define('DB_PASSWORD', '**password**');
       ```
   
 * define(‘DB_HOST’, ‘192.168.0.***’);
 *     ```
       define('DB_CHARSET', 'utf8');
       ```
   
 * define(‘DB_COLLATE’, ”);
 *     ```
       $table_prefix  = 'wp_';
       ```
   
 * define (‘WPLANG’, ”);
 * On IIS6 box, [http://localhost/wp-admin/install.php](http://localhost/wp-admin/install.php)
   gives…
 * **The Error(s)**
    WordPress database error Table ‘**database**.wp_options’ doesn’t
   exist for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’
   WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query
   SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ WordPress
   database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT
   option_name, option_value FROM wp_options … WordPress database error Table ‘**
   database**.wp_options’ doesn’t exist for query SELECT option_name, option_value
   FROM wp_options WordPress database error Table ‘**database**.wp_options’ doesn’t
   exist for query SELECT option_value FROM wp_options WHERE option_name = ‘cron’
   LIMIT 1 WordPress database error Table ‘**database**.wp_options’ doesn’t exist
   for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’
 * **The Question**
    If I were to manually create this table using the credentials
   assigned to WordPress, what would it look like? I’m open to other suggestions,
   of course.
 * TIA,
    -dhbarr.

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

 *  Thread Starter [dhbarr](https://wordpress.org/support/users/dhbarr/)
 * (@dhbarr)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/database-error-wp_options-doesnt-exist/#post-676574)
 * As a followup, would anyone mind pointing me to a known-good “phpinfo(INFO_MODULES);”?
   I’d like to see if perhaps my plugins aren’t behaving correctly (I know they’re
   loaded, I just don’t know what good WordPress-compatible behavior looks like).
 * Thanks Again,
    -dhbarr.
 *  Thread Starter [dhbarr](https://wordpress.org/support/users/dhbarr/)
 * (@dhbarr)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/database-error-wp_options-doesnt-exist/#post-676712)
 * Anybody? As an alternative, has anyone ever extracted the SQL schema? I’m thinking
   of setting up a standalone installation, backing up the .sql CREATEs, and trying
   to force creation of the tables (which I have verified are not being created)
   before running setup….
 * -dhbarr.
 *  Thread Starter [dhbarr](https://wordpress.org/support/users/dhbarr/)
 * (@dhbarr)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/database-error-wp_options-doesnt-exist/#post-676754)
 * MichaelH helped me get this resolved over at:
    [http://wordpress.org/support/topic/150484](http://wordpress.org/support/topic/150484)
 * The word is: some combinations of IIS6 + FastCGI + PHP5 work; some do not. Using
   php5isapi.dll as your .php handler seems more reliable.

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

The topic ‘Database Error: wp_options doesn’t exist’ is closed to new replies.

## Tags

 * [fastcgi](https://wordpress.org/support/topic-tag/fastcgi/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 1 participant
 * Last reply from: [dhbarr](https://wordpress.org/support/users/dhbarr/)
 * Last activity: [18 years, 4 months ago](https://wordpress.org/support/topic/database-error-wp_options-doesnt-exist/#post-676754)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics