How To access Phpmyadmin in Wordpress Installation

Posted May 5, 2020 5.1k views

I have recently installed wordpress in my digitalocean. now i want to Import my old database into my new installation. for that i need to access my phpmyadmin. so how can i access ? please let me know.

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.

Submit an Answer
2 answers

Hi there @dhameliyamilan972,

You would need to install PHPMyAdmin first. In order to do that you can follow this step by step tutorial here:

Hope that this helps!

by Brennen Bearnes
by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.

Hi @dhameliyamilan972,

If you want to access PHPMyAdmin in Wordpress installation because you want to manage your database, So here hoe to do this?

To install PHPMyAdmin, run a simple command:

sudo apt install phpmyadmin

If you’re using apache server, then do this:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

sudo a2enconf phpmyadmin.conf

sudo service apache2 reload

If you’re using Nginx, then do this:

sudo ln -s /user/share/phpmyadmin /var/www/public_html/phpmyadmin

nginx -s reload

/var/www/public_html/ - This is location direcotry location of wordpress site

To access the phpmyadmin, Type https://yourdomain/phpmyadmin