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.
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
Hi there @dhameliyamilan972,
You would need to install PHPMyAdmin first. In order to do that you can follow this step by step tutorial here:
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04
Hope that this helps! Regards, Bobby