How to Deploy phpMyAdmin with One-Click Apps

Updated , by Ben Bigger

Traducciones al Español
Estamos traduciendo nuestros guías y tutoriales al Español. Es posible que usted esté viendo una traducción generada automáticamente. Estamos trabajando con traductores profesionales para verificar las traducciones de nuestro sitio web. Este proyecto es un trabajo en curso.
Try this guide to receive $100 at signup on a new account.

phpMyAdmin One-Click App

phpMyAdmin is an open source web application that provides a GUI for MySQL database administration, giving you a convenient and powerful alternative to using the MySQL command line client. The phpMyAdmin One-Click App deploys a Linode with phpMyAdmin installed and ready for you to begin managing a MySQL database.

Deploy a phpMyAdmin One-Click App

Linode’s One-Click App Marketplace allow you to easily deploy software on a Linode using the Linode Cloud Manager. To access Linode’s One-Click App Marketplace:

  1. Log in to your Linode Cloud Manager account.

  2. From the Linode dashboard, click on the Marketplace button in the left-hand navigation menu.

  3. The Linode creation page will appear, with the One-Click and Marketplace tabs pre-selected.

  4. Under the Select App section, select the app you would like to deploy:

    Select a One-Click App to deploy

  5. Once you have selected the app, proceed to the app’s Options section and provide values for the required fields.

phpMyAdmin Options

ConfigurationDescription
phpMyAdmin/MySQL Admin UserThe admin username for accessing your phpMyAdmin dashboard. Required.
phpMyAdmin/MySQL Admin PasswordThe admin user password for accessing your phpMyAdmin dashboard. Required.
MySQL root PasswordThe root user password for your MySQL database. Required.
Note
phpMyAdmin doesn’t handle user management itself, but passes all user information onto MySQL. The Admin User you create here is created in MySQL.

Linode Options

The following configuration options are possible for your Linode server:

ConfigurationDescription
Select an ImageDebian 9 is currently the only image supported by the phpMyAdmin One-Click App, and it is pre-selected on the Linode creation page. Required.
RegionThe region where you would like your Linode to reside. In general, it’s best to choose a location that’s closest to you. For more information on choosing a DC, review the How to Choose a Data Center guide. You can also generate MTR reports for a deeper look at the network routes between you and each of our data centers. Required.
Linode PlanYour Linode’s hardware resources. If you decide that you need more or fewer hardware resources after you deploy your app, you can always resize your Linode to a different plan. Required.
Linode LabelThe name for your Linode, which must be unique between all of the Linodes on your account. This name will be how you identify your server in the Cloud Manager’s Dashboard. Required.
Root PasswordThe primary administrative password for your Linode instance. This password must be provided when you log in to your Linode via SSH. The password must meet complexity strength validation requirements for a strong password. Your root password can be used to perform any action on your server, so make it long, complex, and unique. Required.

When you’ve provided all required Linode Options, click on the Create button. Your phpMyAdmin app will complete installation anywhere between 1-5 minutes after your Linode has finished provisioning.

Software Included

The phpMyAdmin One-Click App will install the following required software on your Linode:

SoftwareDescription
phpMyAdminphpMyAdmin is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server.
MariaDBMariaDB is a fork of the popular cross-platform MySQL database management system and is considered a full drop-in replacement for MySQL.
Note
Currently, Linode does not manage software and systems updates for One-Click Apps. It is up to the user to perform routine maintenance on software deployed in this fashion.

Getting Started After Deployment

After installation is complete, the phpMyAdmin dashboard is accessible at your Linode’s IP address followed by /phpmyadmin for example:

http://your.linode.ip.address/phpmyadmin

However, entering your phpMyAdmin credentials through an HTTP connection is insecure. The next section provides instructions on how to enable HTTPS access to the phpMyAdmin dashboard from your domain by using Certbot to issue a free Let’s Encrypt SSL Certificate so that you can access your phpMyAdmin deployment securely.

Configure Your Domain with DNS Manager

The following sections require that you own a domain that has been configured for your use with your phpMyAdmin Linode. Following the instructions in the Linode DNS Manager guide, configure your domain’s name servers and add a DNS record so that your domain is pointing to your phpMyAdmin Linode.

Enable HTTPS with Certbot

  1. Connect to Your Linode via SSH.

  2. Install Certbot for authentication with Python and Apache:

    sudo apt-get install certbot python-certbot-apache
    
  3. Run the Certbot script for Apache:

    sudo certbot --apache
    
  4. Complete the prompts from the Certbot script to create and deploy SSL certificates for your domain.

  5. Update your Linode’s firewall to allow HTTPS access:

    sudo ufw allow https
    

Access the phpMyAdmin dashboard

  1. In your browser, navigate to the following address, replacing www.example.com with the address of your domain:

    https://www.example.com/phpmyadmin
    
  2. At the login screen enter the phpMyAdmin/MySQL Admin User and phpMyAdmin/MySQL Admin Password you chose when you deployed the phpMyAdmin One-Click App.

    phpMyAdmin Login Page

  3. You can now access the phpMyAdmin dashboard and begin managing your MySQL database.

    phpMyAdmin Dashboard

This page was originally published on


Your Feedback Is Important

Let us know if this guide helped you find the answer you were looking for.