Install phpmyadmin

May 30, 2017 4.5k views
MySQL PHP LEMP 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:
https://www.digitalocean.com/community/tutorials/how-to-install-phpmyadmin-on-a-lemp-server

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.

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:127.0.0.1:3306 -N

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

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!