How can i change my database to phpmyadmin?

September 19, 2016 129 views
MySQL PHP Ubuntu

I am trying to change my database to phpmyadmin, my website has been established 2 years ago, and I need to change it now for one of my coders to make an application for my website. How is this possible?

1 Answer


phpMyAdmin is a web app that lets you access your MySQL server through an easy-to-use GUI. You do not need to modify your existing database or MySQL server in any way in order to be able to use phpMyAdmin (unless you have very locked down permissions).

However, setting up phpMyAdmin as a publicly accessible app can be a security risk. I would recommend using a local client instead such as MySQL Workbench or HeidiSQL (and many other alternatives) along with an SSH tunnel so that the MySQL connection goes securely over an SSH connection.

If you still want to use phpMyAdmin, this tutorial should guide you through installing and securing it.

In this article, you'll learn how to create a safe, encrypted tunnel between your computer and your VPS along with how to bypass limits in a corporate network, how to bypass NAT, etc.
Have another answer? Share your knowledge.