I'm trying to set up a WordPress MultiSite following the Create a Network instructions. I have made sure to check and double-check all requirements, and have followed the instructions exactly. When I get to part 4 of Step 5, which is to log in to my site again, I get a message saying "Error Establishing a Database Connection". I then attempt to use the repair utility that automatically shows up when I try to access /wp-admin/. After doing the repair, I get this set of error messages:
wp_1_posts: Table 'espdesig_wrd1.wp_1_posts' doesn't exist wp_1_comments: Table 'espdesig_wrd1.wp_1_comments' doesn't exist wp_1_links: Table 'espdesig_wrd1.wp_1_links' doesn't exist wp_1_options: Table 'espdesig_wrd1.wp_1_options' doesn't exist wp_1_postmeta: Table 'espdesig_wrd1.wp_1_postmeta' doesn't exist wp_1_terms: Table 'espdesig_wrd1.wp_1_terms' doesn't exist wp_1_term_taxonomy: Table 'espdesig_wrd1.wp_1_term_taxonomy' doesn't exist wp_1_term_relationships: Table 'espdesig_wrd1.wp_1_term_relationships' doesn't exist wp_1_commentmeta: Table 'espdesig_wrd1.wp_1_commentmeta' doesn't exist
I've logged into phpMyAdmin to check out the databases, and I can confirm that the default
wp_* tables exist, but the
wp_1_* tables do not exist. I have verified that the DB user has full privileges, including CREATE. I have even tried manually creating a new DB user instead of letting my host do it all automatically, but that didn't make a difference.
This is not the first time I've had a WordPress installation on my server, and there were some left over databases from previous WordPress installations. I thought that these might be interfering, so I deleted all old databases and DB users. I removed all WordPress files and directories so that I could make sure I'm staring fresh. And there was definitely no problem with the regular WordPress install before attempting to activate MultiSite.
I've done some searching, and I have seen other people reporting a similar problem, but I haven't seen anyone's solution yet. Does anyone have any ideas for a solution, or know of some documentation that I can follow to overcome this issue?