Being certainly one of popular app that is web-based manage MySQL databases, phpMyAdmin has already been installed on thousands servers and is included in various hosting control panel like WHM/cPanel and Vesta CP. This article will show you in step by step about how to install and setup phpMyAdmin on either Ubuntu or server that is debian LAMP stack that this instance is Linux, Apache, MariaDB and PHP (this guide additionally works if you work with initial MySQL host).
- A SSH customer like Putty and knowledge that is basic how to use it.
- Basic knowledge about common Unix command to SSH to your server.
- A server or VPS with at least 512MB of RAM (in OpenVZ you can use 256MB but not really recommended). Then you can read my list of recommended VPS providers or this top low end cloud server providers. Quick recommendation: Atlantic.net if you not already have one, Digital Ocean and RamNode.
- Have one currently? Now install Ubuntu or OS that are debian it. In this tutorial I use Debian 8 32-bit on Atlantic’s 512MB cloud server.
- Install Apache, MySQL / MariaDB and PHP on it. How to install LAMP on Debian and Ubuntu.
- About 20 minutes of your time
- a cup of tea or coffee.
Step 1 – Login towards host as root or as individual with root / sudo privilege. In this essay i just login as root therefore I ditch sudo, but then do not hesitate to add sudo prefix to each command.( if you logged in as user,********)
Step 2 – Being a popular software, phpMyAdmin package is available by default at Debian / Ubuntu repository it.( so you can simply make use of apt-get to install********)
apt-get install phpmyadmin -y
Step 3 – throughout the procedure, it’ll ask you variety of concerns therefore answer it consequently. First, select exactly what internet host is operating on your host:
use arrow to navigate and make use of Enter to choose.
Step 4 – phpMyAdmin will ask whether or not to perform configuration that is common or not. Because phpMyAdmin must have a database installed and configured so you better to execute it before it can be used. Choose Yes.
Step 5 – Enter password for administrative individual:
Step 6 – Now define MySQL application password phpmyadmin:
enter that password once more to verify:
Step 7 – That’s it. As soon as done you’ll see something similar to thiis:
Step 8 – open your browser up and access your newly installed phpMyAdmin using this address:
and if you see 404 not found page, then do this: Edit apache2.conf file using either vi or Nano
scrolldown the page and add this at the very bottom:
It should look similar to this:
Now save changes and exit the editor. In Nano it is Control+O then Control+X.
Step 9 – Finally restart Apache and reload it on your browser********) that is again
service apache2 restart ## or in more recent OS (age.g: Debian 8) usage: systemctl restart apache2
It should now show phpMyAdmin login web page:
Step 10 – Login the first-time making use of root as username together with password you defined early in the day. As soon as logged in, then you’re able to produce database that is new new database user and assign proper privilege of that user to the database. Well, there are many management that is mysql you are able to do via phpMyAdmin.
Congratulation it’s simple to handle your MySQL databases via globe’s well-known phpMyAdmin, a web user interface to handle and arrange all of your mysql databases. Follow me personally on twitter for quicker revision.
This post phpMyAdmin Setup on LAMP Ubuntu and Debian Server is element of ServerMom.