Question

How can i change my database to phpmyadmin?

Posted September 19, 2016 1.1k views
UbuntuMySQLPHP

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?

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.

×
1 answer

Hi!

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.
Submit an Answer