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.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×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.
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.
@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.
@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
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.