Deploying phpMyAdmin through the Linode Marketplace
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 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.
Deploying the phpMyAdmin Marketplace App
The Linode Marketplace allows you to easily deploy software on a Linode using the Linode Cloud Manager.
Log in to the Cloud Manager and select the Marketplace link from the left navigation menu. This displays the Linode Compute Create page with the Marketplace tab pre-selected.
Under the Select App section, select the app you would like to deploy.
Fill out all required Options for the selected app as well as any desired Advanced Options (which are optional). See the Configuration Options section for details.
Complete the rest of the form as discussed within the Getting Started > Create a Linode.
Click the Create Linode button. Once the Linode has provisioned and has fully powered on, wait for the software installation to complete. If the Linode is powered off or restarted before this time, the software installation will likely fail. To determine if the installation has completed, open the Linode’s Lish console and wait for the system login prompt to appear.
Follow the instructions within the Getting Started After Deployment section.
Software installation should complete within 1-5 minutes after the Linode has finished provisioning.
Configuration Options
phpMyAdmin Options
| Configuration | Description |
|---|---|
| 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.
General Options
For advice on filling out the remaining options on the Create a Linode form, see Getting Started > Create a Linode. That said, some options may be limited or recommended based on this Marketplace App:
- Supported distributions: Debian 9
- Recommended minimum plan: All plan types and sizes can be used.
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
Install Certbot for authentication with Python and Apache:
sudo apt-get install certbot python-certbot-apacheRun the Certbot script for Apache:
sudo certbot --apacheComplete 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:https://www.example.com/phpmyadminAt 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.
Software Included
The phpMyAdmin Marketplace App will install the following required software on your Linode:
| Software | Description |
|---|---|
| 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.
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