How To Install phpMyAdmin In Ubuntu

Websolutionstuff | Jul-24-2023 | Categories : Laravel PHP

In this article, we will explore the process of installing phpMyAdmin in Ubuntu. phpMyAdmin is a popular web-based administration tool for managing MySQL and MariaDB databases. It provides a user-friendly interface that allows you to perform various database operations such as creating, modifying, and deleting databases, tables, and executing SQL queries.

In the following sections, we will provide you with a step-by-step guide on how to install phpMyAdmin on your Ubuntu system. We will cover the necessary commands and configurations to ensure a successful installation.

We will see how to install phpmyadmin in ubuntu 22.04, how to install phpmyadmin in ubuntu 21.10, ubuntu 21.04, ubuntu 20.04, ubuntu 18.04 and ubuntu 16.04.

So, let's get started and learn how to install phpMyAdmin in Ubuntu.

Install MySQL on Ubuntu

Update Package Lists

Open a terminal window and run the following command to update the package lists.

sudo apt update

 

Install MySQL Server

Once the package lists are updated, you can proceed to install MySQL Server by running the following command:

sudo apt install mysql-server

 

Install Phpmyadmin

Then, you can proceed to install phpMyAdmin by running the following command

sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl

 

Create a User on MySQL

Now, we will create a user for MySQL using the following command.

mysql -u root -p
  
CREATE USER 'root'@'localhost' IDENTIFIED BY 'password';
     
GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';
  
FLUSH PRIVILEGES;

Now you can go to your browser and open IP or localhost then you will find the below layout:

http://localhost/phpmyadmin

http://your_domain_or_IP/phpmyadmin

Output:

ubuntu-phpmyadmin

 

Resolved: The requested URL /phpmyadmin was not found on this server

After you restart Apache2 you may not be able to see the phpmyadmin login page.

Open apache.conf file:

sudo nano /etc/apache2/apache2.conf

Then add the following line to the end of the file.

Include /etc/phpmyadmin/apache.conf

Restart Apache:

sudo /etc/init.d/apache2 restart

 


You might also like:

Recommended Post
Featured Post
How to Uninstall Composer on Ubuntu 23.04
How to Uninstall Composer on U...

Hey there! If you've found your way to this guide, chances are you're looking to bid farewell to Composer on you...

Read More

Jan-22-2024

Laravel 9 Paypal Payment Gateway Integration
Laravel 9 Paypal Payment Gatew...

In this article, we will see laravel 9 paypal payment gateway integration. Here, we will learn how to integrate the...

Read More

Jan-17-2023

Razorpay Payment Gateway Integration in Laravel 10 and VueJS 3
Razorpay Payment Gateway Integ...

In the rapidly advancing world of technology, the combination of Laravel 10 and VueJS 3 is unparalleled and exceptionall...

Read More

Aug-30-2023

Laravel 8 Google Pie Chart Example
Laravel 8 Google Pie Chart Exa...

This article will show the laravel 8 google pie chart example. Google charts use to visualize data on you...

Read More

Mar-03-2021