2015-07-12_132849

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).

Prerequisites

  1. A SSH customer like Putty and knowledge that is basic how to use it.
  2. Basic knowledge about common Unix command to SSH to your server.
  3. 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.
  4. 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.
  5. Install Apache, MySQL / MariaDB and PHP on it. How to install LAMP on Debian and Ubuntu.
  6. About 20 minutes of your time
  7. a cup of tea or coffee.

The procedures

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,********)

2015-07-12_132849

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

sample production:

2015-07-12_133100

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:

2015-07-12_133132

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.

2015-07-12_133205

Step 5 – Enter password for administrative individual:

2015-07-12_133236

Step 6 – Now define MySQL application password phpmyadmin:

2015-07-12_134216

enter that password once more to verify:

2015-07-12_133319

Step 7 – That’s it. As soon as done you’ll see something similar to thiis:

2015-07-12_133343

Step 8 – open your browser up and access your newly installed phpMyAdmin using this address:

http://x.x.x.x/phpmyadmin

and if you see 404 not found page, then do this: Edit apache2.conf file using either vi or Nano

nano /etc/apache2/apache2.conf

scrolldown the page and add this at the very bottom:

Include /etc/phpmyadmin/apache.conf

It should look similar to this:

2015-07-12_134839

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:

2015-07-12_135724

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.

2015-07-12_140222

Done!

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here