Report this

What is the reason for this report?

How can i change my database to phpmyadmin?

Posted on September 19, 2016

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?



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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!

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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.