How to Deploy phpMyAdmin with Marketplace Apps

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.

phpMyAdmin Marketplace 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 Marketplace App deploys a Linode with phpMyAdmin installed and ready for you to begin managing a MySQL database.

Deploy a phpMyAdmin Marketplace App

Linode’s App Marketplace allows you to easily deploy software on a Linode using the Linode Cloud Manager. To access Linode’s 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 appears, with the Marketplace tab pre-selected.

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

    Select a Marketplace 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 Marketplace 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 Marketplace 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 Marketplace 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 Marketplace App.

    phpMyAdmin Login Page

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

    phpMyAdmin Dashboard

More Information

You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.

This page was originally published on

Create a Linode account to try this guide with a $100 credit.
This credit will be applied to any valid services used during your first 60 days.

Your Feedback Is Important

Let us know if this guide made it easy to get the answer you needed.


Join the conversation.
Read other comments or post your own below. Comments must be respectful, constructive, and relevant to the topic of the guide. Do not post external links or advertisements. Before posting, consider if your comment would be better addressed by contacting our Support team or asking on our Community Site.