How to deploy a MySQL Database Service Instance with PHPMyAdmin

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!

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

One comment

  1. […] (earlier today), I blogged about how to use PHPMyAdmin with a MDS instance. I also showed at the end of the video that it’s possible to open MySQL Router on the compute […]

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.