I am having an odd issue.
I created a bunch of subdomains on my site a few days ago on a different server (same setup.. centos/php/mysql/) and then migrated my site to a new server.
Everything is working, including the subdomains sites I created on the old server. I can view the blogs, write posts, whatever.
However I am not able to create any NEW subdomain sites successfully. After I create a new subdomain site, and try to visit it, I get a server error, "Error establishing database connection" . When I view the list of sites, the new site IS listed there. If I hover over the 'view' link for the blog, the URL is actually itself (the current admin url) rather than the url to the blog like the other functioning ones.
The rest of the site works, just hte new one throws this error. If I visit /wp-admin then it tells me to repair the database tables. When I do that, I get this:
NEWEST_wp_33_posts: Table 'cssinthecloud.NEWEST_wp_33_posts' doesn't exist NEWEST_wp_33_comments: Table 'cssinthecloud.NEWEST_wp_33_comments' doesn't exist NEWEST_wp_33_links: Table 'cssinthecloud.NEWEST_wp_33_links' doesn't exist NEWEST_wp_33_options: Table 'cssinthecloud.NEWEST_wp_33_options' doesn't exist NEWEST_wp_33_postmeta: Table 'cssinthecloud.NEWEST_wp_33_postmeta' doesn't exist NEWEST_wp_33_terms: Table 'cssinthecloud.NEWEST_wp_33_terms' doesn't exist NEWEST_wp_33_term_taxonomy: Table 'cssinthecloud.NEWEST_wp_33_term_taxonomy' doesn't exist NEWEST_wp_33_term_relationships: Table 'cssinthecloud.NEWEST_wp_33_term_relationships' doesn't exist NEWEST_wp_33_commentmeta: Table 'cssinthecloud.NEWEST_wp_33_commentmeta' doesn't exist
So it seems it is not able to create the database tables. I am 100% positive that the database user has been granted all permissions. I even swapped out the username for the admin/root user to double check.
I have followed all the wordpress standard instructions for setting up multi-site, and the site was working just fine a few days ago. The only thing I did was move to another server that was set up with the same software.
I don't understand why the database tables are not getting created.
I have disabled all plugins and tested it.