PhpMyAdmin
PhpMyAdmin
by DigitalOcean

VERSION 4.6.6

OS Ubuntu 18.04

Create PhpMyAdmin Droplet

Description

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

Software Included

PackageVersionLicense
phpMyAdmin4.6.6GPL 2
MySQL Server5.7.23GPL 2 w/modifications
Apache2.4.29Apache 2
PHP7.2PHP v3.01
Certbot0.23.0Apache 2

Getting started after deploying PhpMyAdmin

In addition to the package installation, the One-Click also:

  • Enables the UFW firewall to allow only SSH (port 22, rate limited), HTTP (port 80), and HTTPS (port 443), and MySQL (3306) access.

  • Sets the MySQL root password and runs mysql_secure_installation.

  • Sets the phpMyAdmin admin password.

  • Sets up the debian-sys-maint user in MySQL so the system’s init scripts for MySQL will work without requiring the MySQL root user password.

After you create a phpMyAdmin One-Click Droplet:

  • You can access phpMyAdmin immediately by visiting the Droplet’s IP address in your browser followed by /phpmyadmin.

  • You can log into the Droplet as root using either the password emailed to you or with an SSH key if you added one during creation.

  • The MySQL root password and phpMyAdmin admin password are in /root/.digitalocean_password.

  • You can get information about the PHP installation by logging into the Droplet and running php -i.

In addition, we recommend taking steps to further secure the phpMyAdmin installation, like enabling SSL for the connection from phpMyAdmin to the database server.

  • The default landing page, shown when you visit the Droplet’s IP address, is located at /var/www/html.

  • The phpMyAdmin configuration file is located at /etc/phpmyadmin/. To secure your connection, you will need a registered domain configured for your Droplet.

API Creation

In addition to creating a Droplet from the PhpMyAdmin 1-Click App via the control panel, you can also use the DigitalOcean API.

As an example, to create a 4GB PhpMyAdmin Droplet in the SFO2 region, you can use the following curl command. You’ll need to either save your API access token to an environment variable or substitute it into the command below.


  curl -X POST -H 'Content-Type: application/json' \
       -H 'Authorization: Bearer '$TOKEN'' -d \
      '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image":"phpmyadmin-18-04"}' \
      "https://api.digitalocean.com/v2/droplets"
      

Support Details

Supported By:DigitalOceanDigitalOcean
Support URL:https://www.phpmyadmin.net/support/

Learn More

Product Docs

Technical overviews, how-tos, release notes, and support material

Tutorials

DevOps and development guidelines

API Docs

Run your resources programmatically

Ask a question

Connect, share and learn