Grid Guides

Explore How System On Grid Can Work For You

MySQL One-Click App Setup


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

  1. To create your application, you must create a Photon. You can do so by selecting the Photon tab after selecting 'Create Orbit'

    Photons
  2. 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

    Photon List Photon Description
  3. Scroll down to the details and you can start selecting options for your photon as well as setting up credentials.

    Photon Details
  4. Once everything is filled in, just press Create and you can move on to the next step

SSH into Orbit

  1. First we need to check some details on our orbit by first navigating to the “My Orbits” tab.

    My Orbits
  2. 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)

    Orbit Details
  3. Once you have confirmed that your Orbit is running and you have the other information. Open up your console.

  4. Now you can SSH into your Orbit by running.

    ssh [email protected]
    • 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 [email protected]

Starting MySQL

  1. Once you are SSH'd into the server you will see the following.

    MySQL CMD
  2. 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

    MySQL Login