Accessing Bluemix MySQL Database From External Server

In our previously published guide, we have shown the steps to install WordPress on IBM BlueMix. Of course we have shown basic example commands to check MySQL database from remote server. In this guide, we will discuss how you’ll be accessing Bluemix MySQL database from external server with root access. On CLI you need MySQL Client to work on MySQL.Definitely you can use localhost like Mac, GNU/Linux. We are not used with Microsoft Windows around sysadmin works – you should consult to their latest official guide for bash, we only can point towards cygwin for Microsoft Windows.

 

Accessing Bluemix MySQL Database From External Server

 

In our WordPress installation on IBM Bluemix guide, we have directed to select Compose for MySQL on Bluemix while creating MySQL database. At this moment, Bluemix has another flavour of MySQL which is managed by Cleardb. There are some differences between two options. You’ll get an IP with Cleardb MySQL instead of fully qualified domain name (FQDN) in case of Compose for MySQL. In this example, we are using Compose for MySQL.

If you click on the View credentials button of MySQL service box, where you’ll see a dialog with the service configuration and credentials in JSON format. Copy-paste and save it somewhere. It will have lines like :

From the above example, our command to login to Bluemix hosted MySQL database from external server’s SSH is :

Password in the above case is ABCDEFGHIJ. You’ll receive usual MySQL server response :

 

Commands For MySQL Database Server

 

It is beyond scope of this article to discuss about MySQL server commands. All commands are available on official documentation of MySQL website and in our many older guides we talked about how to backup MySQL database, how to use cloud database etc. Obviously commands are same. We are providing just few basic examples in this guide.

If you run show databases; command you’ll get this kind of output :

To navigate inside the database named compose in the above example, we will run use compose; command. Which will return this confirmatory output :

To view the tables of the database, we will run show tables; command :

We can take backup (create MySQL dump), restore from backup etc.

If you need to test database connection with PHP script, you can use this simple script :

Obviously complex and secure method exists for on-premise :