Tutorial Install and Secure phpMyAdmin on Fedora

PhpMyAdmin is the most popular program for managing MySQL databases, which you can use to execute any SQL statement. The best part about this tool is that you can access it directly from cPanel. After reading this post you will fully learn How to Install and Secure phpMyAdmin on Fedora. We suggest that you stay with us until the end of this article and comment on your opinion at the end.

What is phpMyAdmin?

PhpMyAdmin is a free and open-source management tool for MySQL and MariaDB written in PHP and has become one of the most popular MySQL management tools. PhpMyAdmin supports a wide range of operations in MySQL and MariaDB. You can perform a variety of actions on the database with phpMyAdmin, such as modifying or deleting databases, tables, fields, or rows, executing SQL statements, or managing users and accesses. PhpMyAdmin is translated into 72 languages and supports RTL and LTR languages, so many people can it easily. You need to create a Database to use and manage phpMyAdmin in cPanel.

PhpMyAdmin Features

1. Simple Web Interface 2. Manage MySQL database and support its features 3. Manage users and their access levels 4. Create a table 5. Backup of the database in SQL, XML, CSV, and pdf formats 6. Export the database as a zip file with SQL extension 7. Import database in compressed formats such as CSV and SQL 8. Create pdf graphics from database designs 9. Manage multiple servers

Prerequisites

– A Linux VPS with Fedora Operating System – Apache – PHP – MySQL

How to Install phpMyAdmin on Fedora

In this section, we want to teach you installing phpMyAdmin on Fedora. First, you need to install Apache HTTP and PHP servers by entering the following command:

sudo dnf -y install httpd php php-cli php-php-gettext php-mbstring php-mcrypt php-mysqlnd php-pear php-curl php-gd php-xml php-bcmath php-zip

Now you should edit and set the configuration file /etc/httpd/conf/httpd.conf:

ServerAdmin [email protected]
ServerName example.com
ServerTokens Prod

You can start the httpd service with the following command:

sudo systemctl start httpd

Next, you should enable the httpd service by executing the following command:

sudo systemctl enable httpd

In this step, you need to enable both http and https services with the help of the following command. Note that the firewalld should be running before doing this:

sudo firewall-cmd --add-service={http,https} --permanent

Remember to reload the firewalld with the following command:

sudo firewall-cmd --reload

You can check PHP installed version by running the following command:

php -v

You can see loaded extensions by entering the following command:

php -m

Before installing phpMyAdmin, you should set the PHP timezone on the file /etc/php.ini:

date.timezone = America

Now it’s time to install phpMyAdmin. To do this, run the following command:

sudo dnf -y install phpMyAdmin

Enter the following command to check the installed version of phpMyAdmin:

rpm -qi phpMyAdmin

Also, you can limit access to phpMyAdmin to trusted networks by running the following command:

sudo vim /etc/httpd/conf.d/phpMyAdmin.conf

After saving the changes, you should restart httpd service with the help of the following command:

sudo systemctl restart httpd

How to Access phpMyAdmin interface on Fedora

You can access phpMyAdmin from your browser by entering the following URL. Remote users can change localhost with the system IP address.

http://localhost/phpMyAdmin

You need to log in with your user of the Database to start administering database operations from the phpMyAdmin web interface.

How to change Authentication Plugin for MySQL on Fedora

First, you should log into MySQL CLI and then change the Authentication Plugin with the following command:

mysql -u root -p

How to Secure phpMyAdmin on Fedora

You should secure phpMyAdmin if there are any unusual requests to access phpMyAdmin on the server. First, you need to edit your phpMyAdmin configuration file:

vim /etc/httpd/conf.d/phpMyAdmin.conf

Finally, you can change the alias access name such following: From

Alias /phpMyAdmin /usr/share/phpMyAdmin

Alias /phpmyadmin /usr/share/phpMyAdmin

Alias /neurondbadmin /usr/share/phpMyAdmin

Alias /neurondbadmin /usr/share/phpMyAdmin

Conclusion

This article taught you how to install and secure phpMyAdmin on Fedora. You can manage multiple MySQL servers by adding multiple remote MySQL servers using a single phpMyAdmin. I hope this article was useful for you.