Install phpmyadmin

Question

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.

Answer 1

hansen May 30, 2017

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.

How To Install phpMyAdmin on a LEMP server

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.

Reply Report

534878350 May 30, 2017

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.
Reply Report
- hansen May 30, 2017
  
  @534878350
  Otherwise you can simply go to https://www.phpmyadmin.net/ and download the ZIP-file, which you upload+extract to the position where you want.
  Or you could use https://www.adminer.org/ which is a single file, but does a lot of the regular functions that phpMyAdmin does.
  
  Reply Report
- hansen May 30, 2017
  
  @534878350
  If you want to install on your WordPress one-click droplet do this:
  
  sudo apt-get install phpmyadmin sudo ln -s /usr/share/phpmyadmin /var/www/html/ sudo service nginx restart
  
  Reply Report
  
  534878350 June 2, 2017
  
  Thanks
  
  Reply Report

Answer 2

534878350 May 30, 2017

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.
Reply Report
- hansen May 30, 2017
  
  @534878350
  Otherwise you can simply go to https://www.phpmyadmin.net/ and download the ZIP-file, which you upload+extract to the position where you want.
  Or you could use https://www.adminer.org/ which is a single file, but does a lot of the regular functions that phpMyAdmin does.
  
  Reply Report
- hansen May 30, 2017
  
  @534878350
  If you want to install on your WordPress one-click droplet do this:
  
  sudo apt-get install phpmyadmin sudo ln -s /usr/share/phpmyadmin /var/www/html/ sudo service nginx restart
  
  Reply Report
  
  534878350 June 2, 2017
  
  Thanks
  
  Reply Report

Answer 3

kamaln7 June 1, 2017

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.

Reply Report

534878350 June 2, 2017

Thanks
Reply Report

Answer 4

534878350 June 2, 2017

Thanks
Reply Report

Related

Question

Install phpmyadmin

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

Install phpmyadmin

Leave a comment

Related

question

install phpmyadmin on lemp ubuntu 16

question

PHP Error Log: authz_core:error - For files that don't exists on my server

question

Connect to DB installed into dedicated VPS (private networking)

question

blocked ip in spam

Looking for something else?