A lot of people need the power of a database system like MySQL, but they might not feel like typing commands in the MySQL terminal is their thing. So here is the solution
phpMyAdmin is a popular open-source web-based tool that allows you to manage your MySQL databases through a web interface. If you are running a LAMP (Linux, Apache, MySQL, PHP) stack on your Ubuntu system, you can easily install phpMyAdmin to manage your databases.
Here are the steps to install phpMyAdmin on Ubuntu:
1.Make sure the system is up to date by running this following command:
sudo apt-get update
2.Install phpmyadmin with this following command:
sudo apt-get install phpmyadmin
3.During the installation process, you will be prompted to select the web server that you want to configure automatically. Select Apache2 and press Enter.
Info: When the prompt appears, “apache2” is highlighted, but not selected. hit the SPACE to select Apache
4.You will be prompted to configure the database for phpMyAdmin with dbconfig-common. Select Yes and press Enter.
5.Enter the MySQL root password and press Enter.
6.Create a new password for phpMyAdmin and press Enter.
7.Press Enter to confirm the password.
8.After installation is complete, we need to configure phpMyAdmin to work with Apache.
9.Create a symbolic link between /usr/share/phpmyadmin and /var/www/html
sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
sudo phpenmod mcrypt
11.Restart Nginx service
sudo nginx service restart
Now, you can access phpMyAdmin by visiting http://your-ip-address/phpmyadmin in your web browser.
You will be prompted to enter the username and password you created during the installation process. Once you are logged in, you can use phpMyAdmin to manage your databases, create tables, and perform other database-related tasks.