Steps to Install phpMyAdmin on CentOS 7 0

phpMyAdmin is a popular web-based tool for managing MySQL or MariaDB databases. It provides an intuitive interface for database management tasks, including creating, editing, and deleting databases, tables, or entries. This guide will walk you through the steps to install phpMyAdmin on a CentOS 7 server.

Prerequisites

Before starting, ensure you have the following:

1. A CentOS 7 server with root or sudo access.

2. A LAMP stack (Linux, Apache, MySQL/MariaDB, PHP) installed and configured.

3. Basic familiarity with using the terminal.

Step-by-Step Installation

Step 1: Update the System

Ensure your system is up-to-date:

Step 2: Install the EPEL Repository

phpMyAdmin is not included in the default CentOS repositories. You need to install the EPEL (Extra Packages for Enterprise Linux) repository:

Step 3: Install phpMyAdmin

Once the EPEL repository is enabled, install phpMyAdmin using the following command:

Step 4: Configure phpMyAdmin

After installation, you need to configure phpMyAdmin to allow access.

1. Open the phpMyAdmin configuration file in a text editor:

2. Locate the following lines in the file and modify them to allow access from your IP address. Replace YOUR_IP_ADDRESS with your actual IP address:

Example:

Alternatively, you can allow access to all by replacing:

With:

3. Save the changes and exit the editor.

Step 5: Restart Apache

To apply the changes, restart the Apache web server:

Step 6: Access phpMyAdmin

1. Open your web browser and navigate to:

Replace SERVER_IP with your server's IP address.

2. Log in using your MySQL/MariaDB username and password.

Step 7: Secure phpMyAdmin (Optional but Recommended)

To enhance security:

1. Restrict access by creating an additional layer of authentication:

You will be prompted to set a password.

2. Edit the phpMyAdmin configuration file again:

3. Add the following lines:

4. Restart Apache:

Troubleshooting

• Error 403 Forbidden: Ensure your IP address is correctly configured in the phpMyAdmin configuration file.

• phpMyAdmin Not Loading: Check Apache and PHP logs for errors:

Conclusion

You have successfully installed and configured phpMyAdmin on your CentOS 7 server. With this setup, you can now manage your databases efficiently via a web interface. Always remember to secure your phpMyAdmin installation to protect your data.

Was this answer helpful? 0 0