How to install phpMyAdmin

phpMyAdmin is a free software for managing MySQL database server. Its GUI front end is relatively easy to use and better than Terminal access if you don’t have much MySQL coding experience.

Requirements for the installation:


 

1. Get phpMyAdmin

Open terminal and run:

sudo apt-get install phpmyadmin

You’ll need to enter a few informations during install:

  • Select Apache2 for server
  • Choose YES when asked about whether to Configure the database for phpmyadmin with dbconfig-common
  • Enter MySQL password when prompted
  • Enter password that you’ll use for phpMyAdmin login

2. Add phpMyAdmin to the apache configuration

Enter:

sudo nano /etc/apache2/apache2.conf

Include phpMyAdmin config file

Include /etc/phpmyadmin/apache.conf

Restart apache server or your installation will not work:

sudo service apache2 restart

3. Run phpMyAdmin on your server

Open your browser and enter following address:

http://localhost/phpmyadmin

 

Thats it!

Login with your username and password and start building databases. 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *