How To Install phpMyAdmin On LAMP

Looking for a simple, stable and significant VPS as your web hosting? Check out DigitalOcean, only $5 per month, and you can get $10 in credit just for signing up now.

phpMyAdmin is easy for you to add, optimize and export databases, but it is not included in the LAMP package as default.

To install the latest version of phpMyAdmin, you can check out this VPS tutorial for reference, but which will be a little difficult, instead, you can install the default version on LAMP in the Ubuntu OS packages with the following one command line:

apt-get install phpmyadmin

Press the Enter key, then you will see something like the following window:

How to install phpMyAdmin on LAMP

In the end of the window, you will see such a question:

Do you want to continue [Y/n]?

Enter "y" and press the Enter Key, then you will see such a window:

Choose Apache to run phpMyAdmin

As default, Apache will run phpMyAdmin, so you don’t need to do anything else but just press the Enter key, then you will come to the following window:

Configure phpMyAdmin

Just press the Enter key, then you will see the following window:

phpMyAdmin MySQL password

Remember to enter the password you set for the MySQL user "root" in the above window, press the Enter key, you will see another window:

phpMyAdmin User Password

In the above window, you can enter ANY password for the user "phpmyadmin", press the Enter key and enter the password again in the next coming window, then your phpMyAdmin will be installed successfully.

After that, open the "apache2.conf" file with the following command:

vi /etc/apache2/apache2.conf

And add the following line of code in the end:

Include /etc/phpmyadmin/apache.conf

Just as what you can see from the following screenshot:

How to install phpmyadmin apache conf

Then, restart the apache with the following command line:

/etc/init.d/apache2 restart

Visiting http://yourdomain/phpmyadmin on your browser, if you can see such a landing page:

phpMyAdmin landing page

Then your phpMyAdmin is ready for use, and you can log in with the MySQL user "root" and its password.

Spread the love
This entry was posted in Other Free Nuts and tagged , , . Bookmark the permalink.