How to Deploy phpMyAdmin with Marketplace Apps
Traducciones al EspañolEstamos 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:
Log in to your Linode Cloud Manager account.
From the Linode dashboard, click on the Marketplace button in the left-hand navigation menu.
The Linode creation page appears, with the Marketplace tab pre-selected.
Under the Select App section, select the app you would like to deploy:
Once you have selected the app, proceed to the app’s Options section and provide values for the required fields.
|phpMyAdmin/MySQL Admin User||The admin username for accessing your phpMyAdmin dashboard. Required.|
|phpMyAdmin/MySQL Admin Password||The admin user password for accessing your phpMyAdmin dashboard. Required.|
|MySQL root Password||The root user password for your MySQL database. Required.|
NotephpMyAdmin doesn’t handle user management itself, but passes all user information onto MySQL. The Admin User you create here is created in MySQL.
The following configuration options are possible for your Linode server:
|Select an Image||Debian 9 is currently the only image supported by the phpMyAdmin Marketplace App, and it is pre-selected on the Linode creation page. Required.|
|Region||The 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 Plan||Your 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 Label||The 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 Password||The 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.
The phpMyAdmin Marketplace App will install the following required software on your Linode:
|phpMyAdmin||phpMyAdmin is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server.|
|MariaDB||MariaDB is a fork of the popular cross-platform MySQL database management system and is considered a full drop-in replacement for MySQL.|
NoteCurrently, 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:
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
Install Certbot for authentication with Python and Apache:
sudo apt-get install certbot python-certbot-apache
Run the Certbot script for Apache:
sudo certbot --apache
Complete the prompts from the Certbot script to create and deploy SSL certificates for your domain.
Update your Linode’s firewall to allow HTTPS access:
sudo ufw allow https
Access the phpMyAdmin dashboard
In your browser, navigate to the following address, replacing
www.example.comwith the address of your domain:
At the login screen enter the phpMyAdmin/MySQL Admin User and phpMyAdmin/MySQL Admin Password you chose when you deployed the phpMyAdmin Marketplace App.
You can now access the phpMyAdmin dashboard and begin managing your MySQL database.
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