Using phpMyAdmin to Manage MySQL Databases

phpMyAdmin is a popular web-based database management tool for MySQL and MariaDB. It provides an intuitive graphical interface to interact with databases, execute queries, and perform administrative tasks. This tutorial will guide you through installing and using phpMyAdmin to manage your MySQL databases.

Prerequisites

• A Linux server with Apache or Nginx installed.
• MySQL or MariaDB installed on your server.
• PHP installed with required extensions.

1. Installing phpMyAdmin

You can install phpMyAdmin from the default repositories. Open your terminal and run the following commands:

• For Ubuntu:

  sudo apt update
  sudo apt install phpmyadmin -y

• For Debian:

  sudo apt update
  sudo apt install phpmyadmin -y

• For CentOS/RHEL:

  sudo yum install epel-release
  sudo yum install phpmyadmin -y

2. Configuring phpMyAdmin

During the installation process, you will be prompted to choose the web server that should be automatically configured to run phpMyAdmin. Select Apache or Nginx, based on your setup.

If you are using Apache, you may need to enable the phpMyAdmin configuration:

sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf

In the configuration file, ensure it’s set correctly. You may also want to restrict access to the phpMyAdmin interface by allowing only certain IPs:

<Directory /usr/share/phpmyadmin>
    Options FollowSymLinks
    DirectoryIndex index.php
    AllowOverride All
    Require all granted
</Directory>

3. Securing phpMyAdmin

It is crucial to secure your phpMyAdmin installation. One way to enhance security is to set up an additional layer of authentication using .htaccess. To create a .htaccess file:

sudo nano /usr/share/phpmyadmin/.htaccess

Add the following lines:

AuthType Basic
AuthName "Restricted Access"
AuthUserFile /etc/phpmyadmin/.htpasswd
Require valid-user

Now create the .htpasswd file:

sudo htpasswd -c /etc/phpmyadmin/.htpasswd username

Replace username with your desired username. You will be prompted to set a password.

4. Restarting Web Server

After configuring, restart Apache or Nginx to apply the changes:

sudo systemctl restart apache2    # For Apache
sudo systemctl restart nginx       # For Nginx

5. Accessing phpMyAdmin

Open a web browser and navigate to:

http://your_domain_or_IP/phpmyadmin

You should see the phpMyAdmin login screen. Enter the MySQL username and password to access the database management interface.

6. Managing MySQL Databases

Once logged in, you can create, manage, and delete databases and tables. You can also execute SQL queries directly from the SQL tab. Key management options include:

• Create Database: Click on the Databases tab, enter the database name, and click Create.
• Import/Export: Easily import or export databases and tables using the respective tabs.
• User Management: Manage MySQL users and privileges under the Privileges tab.

7. Conclusion

By following these instructions, you have successfully installed and configured phpMyAdmin to manage MySQL databases on your server. phpMyAdmin offers a flexible and powerful interface for database administration, making it easier to work with MySQL in a web-based environment.

About the Author

Dorian Kane

Author

View All Posts