Introduction

phpMyAdmin is a web-based graphical interface for the database servers MariaDB and MySQL. It was previously used mainly with MySQL databases up until the release of MariaDB, the fully backwards-compatible and open source fork of MySQL. In this tutorial we’ll show you how to access your MariaDB and phpMyAdmin Stack.

Accessing Your Application

Once you’ve built your stack, point your browser to http://your_ip_address/phpmyadmin. You’ll see a popup dialog box asking you for credentials before you can even see the phpMyAdmin login page. In order to get to the login page you’ll need to SSH into your machine, where you’ll be shown all your access credentials. If you don’t know how to SSH into your machine, check out our “Getting Started with Your Stack” tutorial.

Once you’ve logged into your machine using SSH, you’ll see a block of text logged to your terminal. This is called the message of the day (MOTD) and it contains a lot of sensitive information regarding your Ghost application. We highly recommend you take note of these credentials somewhere safe and run rm -f /etc/motd to remove the MOTD. Using the first set of credentials, authenticate with the popup box prompting you for a password earlier. Once you’ve entered your username and password, you’ll be shown the phpMyAdmin login page. You can login here using the ‘admin’ account created for you or with the ‘root’ account. The passwords to both these users can again be found in the MOTD.

Final Words

The web interface of phpMyAdmin allows you to explore all the information in your database without having to write complex SQL queries from the command line. You’re all set to start manipulating your data and extracting important information from it. From all of us at Stack Harbor, ahoy!