Google+ Badge

Wednesday, December 24, 2014

How to Install Phpmyadmin in Ubuntu 14.04

How to Install Phpmyadmin in ubuntu 14.04

Phpmyadmin is a free tool used to administrative MySQL database in a GUI mode (Using web browser). You can perform almost all the major tasks like creating , deleting  and modifying databases, tables, rows etc. you can also optimize and repair tables just with a single click .

Note : Before you get started with this, you need to install LAMP or MySql-Server on this server.

Step 1 - Update Ubuntu repositories and install phpmyadmin
     root@digidom:~# apt-get update
     root@digidom:~# apt-get install phpmyadmin

Step 2 - During installation you will be asked to select a Web server to run the phpmyadmin interface. Hit "SPACE", "TAB", and then "ENTER" to select Apache.

Step 3 - You will be asked to configure a database for phpMyAdmin.  Select Yes and press Enter.

Note : If you already configured mysql-server manually, just choose “No” and hit enter to complete the installation.

Step 4 - Provide a password for the Database Administrative user.

Step 5 - Provide a MySQL application password for phpmyadmin.

Success, phpMyAdmin installation has been completed now.

Step 6 - The installation process actually adds the phpMyAdmin Apache configuration file into the "/etc/apache2/conf-enabled/ "Directory, where it is automatically read.

Step 7 - Restart apache service.
     root@digidom:~# service apache2 restart

Step 8 - Launch a Web browser and login to phpMyAdmin with the username and password created during installation "http://Your-Server-IP-Address/phpmyadmin/".
You will be redirected to PhpMyAdmin main web interface.

Now, you can manage your MySQL databases from phpMyAdmin web interface.

Additional Note : phpMyAdmin should work well. In case phpMyAdmin is not working "page not found", please do the following steps and add to end of line.

     root@digidom:~# vi /etc/apache2/apache2.conf
     Include /etc/phpmyadmin/apache.conf
     root@digidom:~# service apache2 restart

That’s it......