phpMyAdmin is an open-source MySQL and MariaDB administration tool that allows you to manage your databases, tables, users, and much more through a web-based interface. In this blog post, we will walk you through the process of installing and configuring phpMyAdmin on Ubuntu.
To follow this tutorial, you will need:
- An Ubuntu server
- Apache, MySQL, and PHP installed (commonly referred to as a LAMP stack)
- Access to a terminal or command line interface
- Basic knowledge of Linux commands and MySQL
Step 1: Install phpMyAdmin
The first step is to install phpMyAdmin on your Ubuntu server. To do this, run the following command to update your package index and install the required packages:
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json -y
During the installation process, you will be prompted to choose a web server. Select “apache2” by using the spacebar to mark it and then press Enter to continue.
You will also be asked if you want to use “dbconfig-common” to set up the phpMyAdmin database. Select “Yes” and enter a password for the phpMyAdmin user when prompted.
Step 2: Configure Apache
Next, you will need to configure Apache to work with phpMyAdmin. Create a symbolic link between the phpMyAdmin configuration file and the Apache configuration directory:
Now, enable the configuration file and restart Apache:
sudo systemctl reload apache2
Step 3: Secure phpMyAdmin
By default, phpMyAdmin can be accessed by anyone who knows the server’s IP address or domain name. To secure it, you can add an additional layer of authentication using Apache’s htpasswd utility. First, install the apache2-utils package:
Create a new password file and add a user:
Enter a password for the user when prompted. Now, edit the phpMyAdmin Apache configuration file:
Add the following lines inside the <Directory> block, replacing “your_username” with the username you created earlier:
AuthType Basic AuthName "Restricted Access" AuthUserFile /etc/phpmyadmin/.htpasswd Require valid-user
Save and exit the file, then reload Apache to apply the changes:
Step 4: Access phpMyAdmin
You can now access phpMyAdmin by navigating to http://your_server_ip_or_domain/phpmyadmin in your web browser. You will be prompted to enter the username and password you created in Step 3, followed by the phpMyAdmin login screen. Log in using the “phpmyadmin” user and the password you set during the installation process.
You have successfully installed and configured phpMyAdmin on your Ubuntu server. You can now manage your MySQL databases, tables, and users through the user-friendly web interface. Make sure to keep your phpMyAdmin installation up-to-date and secure by regularly applying security patches and monitoring access logs.