I recently received several messages from developers not being comfortable with command line when they need to create schemas, tables, … They were asking me for an easy alternative when testing MDS.
There is a very popular tool in the developer community to manage their databases in MySQL: PHPMyAdmin.
So if you are trying MDS (MySQL Database Service in Oracle Cloud Infrastructure), it’s possible to deploy such instance with a compute instance hosting PHPMyAdmin very easily using OCI’s Resource Manager and a stack (zip file) that you can find here: https://github.com/lefred/oci-phpmyadmin-mds/releases/tag/1.1.0
If you want to try MDS in OCI, you can get free credits using this url: https://www.oracle.com/cloud/free/.
Check this video to see this in action:
As you can see, it’s easy and straight forward.
But please don’t forget that opening the database to the World (or MySQL Router to the Internet), is very dangerous and not recommended !
My next short post will show you a better option to manage your MDS instance remotely without security risks!