Installing phpMyAdmin in Ubuntu 16.04

phpMyAdmin is an open source tool used for the administration/management of MySQL or MariaDB with the use of a web browser. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more. Here, we are going to see how to install, up and run phpMyAdmin on Ubuntu 16.04.

Install phpMyAdmin

Before you start installing phpmyadmin, install PHP, apache and MySql or similar Db..

Then.. Run following command .. to install phpMyadmin on your Ubuntu installation...

sudo apt -y update && sudo apt install phpmyadmin

Continue with typing Y once the installation prompts you with Do you want to continue [Y/n]? Like in the image below.

Now we are prompted with dialog selecting our web server, in our case we are selecting apache2 like shown below.

Select <Yes> as we just want a basic installation like shown below.

Now provide a password for phpMyAdmin to use. So that it can register with the MySQL database itself. (Need not to be the same as the MySQL root user)

Enter in the phpMyAdmin password you created in last step to confirm it as follows.

phpMyAdmin is now installed, but, still we have a few more things to do.

Testing phpMyAdmin

Now we will test phpMyAdmin! Open your favorite Web Browser..
and Navigate to http://localhost/phpmyadmin/

If you end up with a page that looks like one shown below... means, phpMyadmin was installed successfully on your system..

Now lets login, the default username for phpMyAdmin is root and the password is what you have entered while installing phpMyadmin... Enter as follows.

Username: root

Password: What you selected earlier

Select Go to login.

When you log in, you'll see the user interface, which will look something like this:

Hi friends, If you found any issue or typo error, please feel free to report it.. You can report it on our Facebook Page via message (www.fb.com/opensourceinside) .

How To Install
Apache Web Server
On Linux

Apache is an open source Web server developed by a loosely-knit group of programmers released under Apache License. The first version of Apache, based on the NCSA httpd Web server, was developed in 1995.

The original version of Apache was written for UNIX, but there are now versions that run under OS/2, Windows and other platforms.
According to wikipedia and FAQ, The name 'Apache' was chosen from respect for the Native American Indian tribe of Apache (Indé), well-known for their superior skills in warfare strategy and their inexhaustible endurance. A common misunderstanding is that it was called Apache because it was developed from existing NCSA code plus various patches, hence the name a patchy server, or Apache server.

Apache Web Servers are often used in combination with the MySQL database engine, the HyperText Preprocessor (PHP) scripting language, and other popular scripting languages such as Python and Perl. This configuration is termed LAMP (Linux, Apache, MySQL and Perl/Python/PHP) and forms a powerful and robust platform for the development and deployment of Web-based applications.

Here, I'm going to show you how to install Apache web server on different Linux systems..

Install Apache Web Server On Ubuntu Linux

Open terminal and run the following command..

sudo apt-get install apache2

Or, On Newer systems (Ubuntu 16.04 and later versions..)

sudo apt install apache2

You can find information about configuring Apache webserver on Ubuntu wikipage

Install Apache Web Server On CentOS, RHEL and Fedora Linux

For Fedora 22 and Later Releases..

sudo dnf -y install httpd

For CentOS, RHEL, Fedora 21 and earlier versions..

sudo yum -y install httpd

Install Apache Web Server on Arch Linux

First, make sure that your Arch Linux System is up-to-date by running following command

sudo pacman -Syu

Now Install Apache web server..

sudo pacman -S apache

Install Apache Web Server on SUSE Linux

sudo zypper install apache2

Install Apache Web Server on Gentoo Linux

Run the following command to ensure that your Gentoo Linux System is up-to-date..

sudo emerge --sync && sudo emerge --update world

Now run the following command to install apache on Gentoo..

sudo emerge -pv apache

Enabling/starting and testing the apache installation..

Enable the httpd service to start automatically on every reboot and start the service with systemd ...

sudo systemctl enable httpd && sudo systemctl start httpd

After successful installation of Apache web server check whether it's working properly or not.. To do so.. Just visit localhost in your web browser. You should see an Apache Test Page, like one shown in following image...

KodeMonk

Friday, September 16, 2016