Open the “nf” file with the command below: nano /etc/httpd/conf.d/nfįind the following lines: Alias /phpMyAdmin /usr/share/phpMyAdminĬomment them both with “#” #Alias /phpMyAdmin /usr/share/phpMyAdmin You can make your phpMyAdmin run with another Alias so the attackers or bots can’t find your login page, Open your phpMyAdmin global configuration with your text editor: nano /etc/phpMyAdmin/įind the following line: $cfg = TRUE Īnd change it like below: $cfg = FALSE In this section, we are going to forbid the root login from phpMyAdmin.(it’s recommended to disable your root login from MySQL as well) In the following sections, we are going to set up some of the most important security methods to prevent bots and attackers from targeting your database: 1. Installing phpMyAdmin allowing you to easily access your MySQL database over the internet which is really handy but it can be a security flaw if you don’t limit the access to it. Now you can install the phpMyAdmin package with the command below: yum install phpmyadminĪfter the installation is finished, you can start with phpMyadmin right away using the following address: PUBLIC_IP_DOMAIN/phpmyadmin Securing the phpMyAdmin You can easily install EPEL using “yum”: yum install epel-release Installing the phpMyAdmin PhpMyAdmin is not provided by the official repository, so you have to add “EPEL” repository in order to install the latest version. How to install LAMP (Apache, MySQL, PHP) stack on CentOS 7 Install phpMyAdmin You need LAMP stack installed and configured if you don’t follow the instructions in the link below: We are assuming that you have root permission, otherwise, you may start commands with “sudo”. working with different operating systems.Searching globally in a database or a subset of it.Creating PDF graphics of the database layout.here are some of the main benefits of phpMyAdmin: phpMyAdmin supports a wide range of operations on MySQL and MariaDB using a very simple and elegant user interface while you still have the ability to directly execute any SQL statement. PhpMyAdmin is a free and open-source software written in PHP programming language to provide you the ability to take control of your MySQL database over the internet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |