Title: Multisite Setup Failure.
Last modified: August 19, 2016

---

# Multisite Setup Failure.

 *  [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/)
 * I get the following errors when I try to enable multisite by adding all the configuration
   stuff that WordPress tells me to.
    The first time I set this up, it did work 
   fine — then I disabled it completely because I needed to move WordPress to the
   root of my site.
 * wp_usermeta is not in my MySQL database, and I think it explains the error I 
   am getting:
 * Error establishing database connection
 * If your site does not display, please contact the owner of this network. If you
   are the owner of this network please check that MySQL is running properly and
   all tables are error free.
 * Could not find site zylblog.info. Searched for table wp_blogs in database <this
   would be my database, I understand it’s a security risk to share…>. Is that right?
 * What do I do now? Read the bug report page. Some of the guidelines there may 
   help you figure out what went wrong. If you’re still stuck with this message,
   then check that your database contains the following tables:
 *  * wp_users
    * wp_usermeta * wp_blogs * wp_signups * wp_site * wp_sitemeta * 
   wp_registration_log * wp_blog_versions

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

 *  [dgilmour](https://wordpress.org/support/users/dgilmour/)
 * (@dgilmour)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1590951)
 * See [http://wordpress.org/support/topic/421623?replies=4#post-1590918](http://wordpress.org/support/topic/421623?replies=4#post-1590918)
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591083)
 * What is the best way to do a “Search and Replace” on my database?
    I am not familiar
   with manipulating MySQL in such a way.
 *  [dgilmour](https://wordpress.org/support/users/dgilmour/)
 * (@dgilmour)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591092)
 * When you backup a MySQL database, e.g. using mysqldump, the resulting file is
   essentially a text file containing the SQL commands needed to recreate the databases
   tables and repopulate them with your data.
 * By carefully editing a copy of that file with a suitable text-only editor (like
   Notepad) you can make the necessary changes. Keep the original as your backup
   in case you need it.
 * Then drop the existing database and restore it from your amended backup file.
   Restoring the database from a backup is something you need to know how to do 
   anyway.
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591115)
 * Okay, database dumped, text searched-and-replaced, database dropped, new database
   executed into MySQL, still the same problem.
    At at the very least, this was 
   a quick way to fix links that would have been pointing to the wrong location 
   in old blog posts.
 * Now what do I do?
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591204)
 * Nothing, eh?
 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591207)
 * Does the db user have all permissions on the database?
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591213)
 * I’ve double checked.
    The database user which I have WordPress configured to 
   use has all permissions on the database.
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591250)
 * Andrea R.:
    I triple checked. I even set up another database permissions instance,
   giving the user full access to everything. I upgraded to WordPress 3.1, and enabled
   Sitemode again and followed the directions — Nothing. What could be the problem?
 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591251)
 * So… you did a brand new install and still got the error connecting database issue?
 *  Thread Starter [zylstra555](https://wordpress.org/support/users/zylstra555/)
 * (@zylstra555)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591254)
 * I did a new *new* install. Exported WordPress, and dropped the database.
    I’ve
   spend the night getting it back up and running. Certainly, this wasn’t exactly
   the way I wanted to go about it; but, it worked.
 * I would like to give a sincere thank-you for your assistance, this has been something
   I’ve wanted to do for a while now.
    – Jesse Zylstra
 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591255)
 * Awesomesauce.

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

The topic ‘Multisite Setup Failure.’ is closed to new replies.

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 11 replies
 * 3 participants
 * Last reply from: [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * Last activity: [15 years, 11 months ago](https://wordpress.org/support/topic/multisite-setup-failure/#post-1591255)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
