Introduction
One of the many available One-Click Apps that we have is MySQL. MySQL is a freely available open source Relational Database Management System (RDBMS that uses Structured Query Language (SQL. SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.
Prerequisites
-
Orbit created with MySQL image
-
Running Orbit
Creating Your Orbit
-
To create your application, you must create a Photon. You can do so by selecting the Photon tab after selecting ‘Create Orbit’
-
Once there, you will see a list of available photons that you can create. Select one and it will bring you to a detailed page
-
Scroll down to the details and you can start selecting options for your photon as well as setting up credentials.
-
Once everything is filled in, just press Create and you can move on to the next step
SSH into Orbit
-
First we need to check some details on our orbit by first navigating to the “My Orbits” tab.
-
Once there, click on the Orbit you want to connect to and check for three things:
-
IP Address
-
Running Status
-
Source Image(Ubuntu, Debian, Centos, Fedora
-
-
Once you have confirmed that your Orbit is running and you have the other information. Open up your console.
-
Now you can SSH into your Orbit by running.
ssh image@address
-
IP Address: We got this from the detail page, in this case it is “216.200.116.60”
-
Image: We got this from the source image in the details page. It should be one of the following: ubuntu, debian, fedora, centos
-
Note: A full command for this example would be: “ssh ubuntu@216.200.116.60”
-
Starting MySQL
-
Once you are SSH’d into the server you will see the following.
-
We first need to connect to the database. You can use the information provided in the welcome message to login.
mysql -u root -p
That’s all there is to it. You can now start using MySQL