I have sites I'd love to bring to Cloudways but I guess I need to keep giving my money to another host.

The proposed workaround from Cloudways does not allow a single user to access both databases (the main app db and the empty stack db). It's 2017. Seriously. Your tool has a "Create new database" option but you deny access. Why? Nobody has yet answered that question. It can access the "Information Schema" database as well as the app database. Why not a third or more? There's no way here to share tables or cross reference due to the user partitioning.

Please, let's get this moving. This functionality has been possible with PHPMyAdmin for years and years. CloudWays can do better here.

I'm confused with your guide for second DB.

The proposed solution doesn't work for a single application that only has a single set of credentials but needs to connect with multiple databases or share tables.

Agree with all the comments so far. This is ridiculous. Honestly, I am considering cancelling my hosting plan with Cloudways because of "permissions" being capped. I had to do so much workaround (especially setting up DNS records) to bypass this limitations that it's not funny. It's easier for me to move all of my sites to a new host than to bypass limitations on Cloudways. Unacceptable.

Might I recommend a separate database container, and potentially have it

(a) reachable via other servers in your account (dynamic acl generation or at least firewall on the sql server)
(b) potentially have other database options, like oracle-xe or postgresql
(c) for mysql container, have multiple databases as an option

I plan to make a multiple Database for my WordPress but since user can't even create a DB. Since my WPMU configuration might get as much as thousand of sub-site later on this will be too much for single database. 16 DB or 256 DB I might need for 100,000+ blogs. Hope you can Implement this for now I'll wait and stick on my current host.

As most already know, this is doable already via:
https://support.cloudways.com/how-do-i-provide-more-than-one-database-for-my-application/

We may consider a cleaner / more direct idea of doing it in the future.

Cloudways Team

This is ridiculous. Especially because inside of the database manager, it has a button for creating a new database .. you can't even RENAME the one database you get. Absolutely insane. Not being able to add multiple databases easily is unpardonable.

When ever I am working with a current installation of an APP for one of my website projects, and would like to add other PHP Apps in support of the project...I have to install another PHP Stack to make that happen.

The reason why I have to do this is the need to access another SQL database for the supporting app. Say PHPList. So the current set up does not allow me to add another data base installation to the application. When ever I try to add another database, I get this Access Denied message.

It would be great if I could add more than one database to an application installation using your Click & Go application so that I can take my web project to the next level, without having to set up a whole other App.

Hi Vrajesh,

Take a look at:
https://support.cloudways.com/entries/96119563-How-do-I-provide-more-than-one-database-for-my-application-

This is the solution that we have in place by now (not extremely neat but it works).

Cloudways Team