Multiple databases per application
. but i does not apply here.. so sad :((
Justin Mayfield commented
Yes, please address this more adequately. Even shared Bluehost plans have built-in phpmyadmin with full management ability for every DB on the account and ability to create new DB's.
Creating a whole new application for a mere DB is a pretty low-quality solution. It makes a slow workflow and it clutters the application list. Without more ability to tag and search applications, this is a fairly low-quality user experience.
The only thing I can think of is creating a DO or Vultr droplet/server directly on their service (so it's cheap) and setting up phpmyadmin there with root access. I may have to do that for adding extra DB's but that doesn't help me to have a central place to manage all of my DB's.
Also, setting up SQL Workbench is a fairly complicated solution for DB management--especially given how generally user-friendly the rest of Cloudways' service is.
I was nearly ready to start migrating my sites to Cloudways from Webfaction but I think this shortcoming might be a dealbreaker.
Almost seems possible, the function is there, but 'access denied'.
This is really sad
Scott Whitlow commented
This is causing us major issues and the workaround provided is *not* sufficient. We need to have a solution that easily allows you to create a new DB in the same instance. It is crazy that you have to create an entire new application just to add a new DB.
Tom Greenwell commented
This would be particularly useful for a staging version of a website at a subdomain. The tool I use to sync site versions (Wordmove) currently does not allow for differing table prefixes.
This is absurd. It is 2017 - what a joke.
So basically for every new database I have to create another application
which is not ideal in real world scenerio
as I will have to maintain so many apps
please let me know if you have plans to improve this
as this is really a huge drawback
It would be awesome to have it!
Yes getting the denied access and no privileges sucks. Please implement this feature.
Yeah, lets get this sorted please.
According to Support they team are working hard to implement a solution to this .. since this was raised as an issue in 2014 first and it is now 2017 I'm not holding my breath.
Can the Cloudways team provide an explanation for this limitation? (apart from the perhaps obvious reason to want users to create multiple instances just for the database and therefore increase costs)
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.
George Tourtsinakis commented
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.
R. Wendel commented
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.