A feature we've been working on for a while now, and which very we're excited about here at Idealstack is point-and-click database management. It's a core feature of most other hosting consoles, and we think it's probably something most people would want versus using the commandline to interact with Mysql.
The new database management tool is enabled by default, but you'll need to redeploy your stack to get it to actually apply to your live AWS account:
Once the stack update has applied you can access the database manager for a given site under the site's Connect tab (you can also find it under the Stack)
Then click Database Manager
This will take you to the database manager
Where you can run queries, create and drop databases, manage database users and so forth
Other popular hosting consoles such as plesk and cpanel all provide a similar tool, so we've opted to turn it on by default, but there's a couple of reasons why you might not want it:
You can turn it off under the stack settings. Click to open the "Optional Features" panel and uncheck the option.
Let's face it, we're all PHP geeks here, so you might be interested in the details of how we built this.
We're using the popular open-source database management tool Adminer, which is simple and secure. Adminer is wrapped up in a docker image and will be rolled out as a seperate service on your ECS Cluster, like your other sites are. We haven't used the more popular PHPMyAdmin for a couple of reasons - Adminer also supports other database types that we are planning to add in the future, it is small and lightweight and presents a smaller security target.
Creating a way to do this securely has been one of our key concerns in building this feature. There's a couple of things we've done to make things secure
We hope you find this feature useful. If you've got any questions or feedback about it we'd be happy to hear them, just email us on email@example.com