SharDB isn’t tailored for implementing a different DB for each site. However, if you don’t have a large number of sites, you can use the VIP DB configuration to use a separate DB for each site.
Does the user root have permission to use the wp_home database?
By virtue of being the super user, root typically has access to all databases. Unless it’s a local development install, using the root user in your wp-config.php should be avoided.
On some systems the name of your database is prefixed with your username
The main place I have seen that is cPanel implementations. If you used cPanel to create your databases then your
– shardb_prefix would be something like account_dbname_
– DBs would be named account_dbname_global, account_dbname_0, account_dbname_1, etc.
You can edit your wp-config.php to see the user that WP is using for the databases. If your DBs follow the naming convention I’ve outlined then check that the user has access to those databases.
Hi!
Ok, I understand, thanks…
where can I find a installation guide for VIP DB configuration to use a separate DB for each site?
Do I have to manually install the new VIP DB databases?
Is not a local development im running, and I always get this error:
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the wp_global database.
Are you sure it exists?
Does the user root have permission to use the wp_global database?
On some systems the name of your database is prefixed with your username, so it would be like username_wp_global. Could that be the problem?
Thanks
Please, some help on getting the plugin to work, thanks…
If WP cannot select the database but the database exists then the WP DB_USER does not have permissions to access the database.
VIP databases:
– you have to create these & migrate the sites tables to them before you can use them
– they have to follow the naming convention of {$shardb_prefix}{NAME}
– configure in db-settings (at the bottom) add_vip_blog( {blog_id}, {NAME} );
Hi!
Ok, thanks, I solved the problem I had 🙂