Title: Database errors on new install
Last modified: August 30, 2016

---

# Database errors on new install

 *  [vivhan](https://wordpress.org/support/users/vivhan/)
 * (@vivhan)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-on-new-install/)
 * I’m getting the following error message in the apache log files when i attempt
   to make a new site:
 * WordPress database error Table ‘wp_mu.wp_3_options’ doesn’t exist for query
 * The page itself just goes white and you have nothing displayed when you click
   create new site.
 * Database was setup as follows:
 * DROP DATABASE IF EXISTS wp_mu;
    CREATE DATABASE IF NOT EXISTS wp_mu; GRANT ALL
   PRIVILEGES ON wp_mu.* TO “wp__mu”@”localhost” IDENTIFIED BY ‘password’; FLUSH
   PRIVILEGES;
 * I’ve added the following lines to WP-config.php
 * /* Multisite */
    define(‘WP_ALLOW_MULTISITE’, true ); define(‘MULTISITE’, true);
   define(‘SUBDOMAIN_INSTALL’, false); define(‘DOMAIN_CURRENT_SITE’, ‘wp.mydomain.
   com’); define(‘PATH_CURRENT_SITE’, ‘/’); define(‘SITE_ID_CURRENT_SITE’, 1); define(‘
   BLOG_ID_CURRENT_SITE’, 1); /* That’s all, stop editing! Happy blogging. */
 * .htaccess contains:
 * RewriteEngine On
    RewriteBase / RewriteRule ^index\.php$ – [L]
 * # add a trailing slash to /wp-admin
    RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$
   $1wp-admin/ [R=301,L]
 * RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d RewriteRule
   ^ – [L] RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
   RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L] RewriteRule . index.php [L]
 * I’m stuck and have no idea what the problem is. The MySQL user seems to be able
   to create the inital site with no issues. However multisite wordpress sites seem
   to fail.
 * Any help would be greatly appreciated

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

 *  Thread Starter [vivhan](https://wordpress.org/support/users/vivhan/)
 * (@vivhan)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-on-new-install/#post-6266607)
 * After a bit of fiddling it looks like the solution is to changing the Database
   charset. From define(‘DB_CHARSET’, ‘utf8mb4’); to
    define(‘DB_CHARSET’, ‘utf8’);
 * The first wordpress site (pre multisite activation) worked fine with utf8mb4,
   so I’m unsure why multisite on my system only seems to work if I change the the
   charset to utf8.
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-on-new-install/#post-6266729)
 * What version of MySQL re you running?
 *  Thread Starter [vivhan](https://wordpress.org/support/users/vivhan/)
 * (@vivhan)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-on-new-install/#post-6266730)
 * It’s: 5.5.43-0ubuntu0.12.04.1
 * which does seem to have support for utf8mb4
 * [http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-3.html](http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-3.html)

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

The topic ‘Database errors on new install’ is closed to new replies.

## Tags

 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 3 replies
 * 2 participants
 * Last reply from: [vivhan](https://wordpress.org/support/users/vivhan/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-on-new-install/#post-6266730)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics