phpMyAdmin is one of the most popular applications for MySQL database management. It is a free tool written in PHP. Through this software, you can create, alter, drop, delete, import and export MySQL database tables.
In this tutorial, i am going to show you how to install and configure PHPMyadmin on ubuntu 22.04 system.
How to install phpMyAdmin on Ubuntu 22.04
Just follow the below given steps to install and configure phpMyAdmin on ubuntu 22.04 system:
- Step 1 – Update System Dependencies
- Step 2 – Install PhpMyAdmin
- Step 3 – Configure PHPMyAdmin
- Step 4 – Restart Apache Server
- Step 5 – Login to PHPMyAdmin
Step 1 – Update System Dependencies
Open command prompt and execute the following command to update latest system dependencies:
sudo apt update
Step 2 – Install PhpMyAdmin
Run the following command to install phpmyadmin on ubuntu 22.04 system:
sudo apt install phpmyadmin
Step 3 – Configure PHPMyAdmin
Run the following command on command prompt to configure phpmyadmin for Apache:
sudo nano /etc/apache2/conf-available/phpmyadmin.conf
After that, add the following line into apache2.conf file and save it:
Alias /phpmyadmin /var/www/html/phpmyadmin Options Indexes FollowSymLinks DirectoryIndex index.php AddType application/x-httpd-php .php php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_value include_path . # Authorize for setup AuthType Basic AuthName "phpMyAdmin Setup" AuthUserFile /etc/phpmyadmin/htpasswd.setup Require valid-user # Disallow web access to directories that don't need it Order Deny,Allow Deny from All Order Deny,Allow Deny from All
Running the following command to enable the configuration:
sudo a2enconf phpmyadmin.conf
Step 4 – Restart Apache Server
Run the following command to restart apache web server on ubuntu 22.04:
sudo service apache2 restart
Step 5 – Login to PHPMyAdmin
Open your browser and type the below url with server ip:
http://[SERVER_PUBLIC_IP]/phpmyadmin
Conclusion
In this tutorial, i have shown to you how to install and configure PHPMyadmin on ubuntu 22.04 system.