How to Deploy phpMyAdmin with One-Click Apps
Updated , by Ben Bigger
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 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:
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 will appear, with the One-Click and Marketplace tabs 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 One-Click 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 One-Click 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 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:
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 One-Click App.
You can now access the phpMyAdmin dashboard and begin managing your MySQL database.
This page was originally published on