Install phpmyadmin

May 30, 2017 3.9k views
LEMP PHP MySQL Ubuntu 16.04

I install WordPress by the site of digital ocean droplet.I want to know the installation if has lemp.If I can install phpmyadmin directly.

2 Answers

Hi @534878350

You can have a look at this tutorial:

If your web-root is different than /usr/share/nginx/www, then you need to change that to reflect your setup.

by Etel Sverdlov
This tutorial covers the installation of phpMyAdmin on a LEMP server (as opposed to a LAMP server). phpMyAdmin is a free software to work with MySQL on the web—it provides a convenient visual front end to the capabilities of MySQL.
  • So can I directly install phpmyadmin by this tutorial?I'm worry about the installation circumstance.Because I directly install the wordpress during contributing the droplet, I'm worry lacking something for the installation circumstance.

Unless you really need phpMyAdmin, I would recommend a more secure approach that is using a MySQL client (such as MySQL Workbench, HeidiSQL, etc.) and accessing the MySQL server through an SSH tunnel.

To set up the tunnel, run:

ssh root@droplet-ip -L 3306: -N

on your local machine, and configure your SQL client to connect to on port 3306.

Have another answer? Share your knowledge.