{"id":3572,"date":"2022-12-05T06:38:35","date_gmt":"2022-12-05T06:38:35","guid":{"rendered":"https:\/\/hostzop.com\/knowledge\/?post_type=manual_kb&p=3572"},"modified":"2023-02-01T07:48:25","modified_gmt":"2023-02-01T07:48:25","slug":"how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache","status":"publish","type":"manual_kb","link":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/","title":{"rendered":"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tIntroduction<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

A sizable percentage of websites and applications use relational database management systems like MySQL and MariaDB. While using the command line to manage their data may not be comfortable for all people.<\/p>

In order to provide a solution in the form of a web-based management interface, a project named phpMyAdmin was developed. We’ll show you how to set up and secure a phpMyAdmin configuration on a CentOS 7 server in this tutorial. The most widely used web server in the world, Apache, will serve as the foundation for this setup.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tPrerequisites<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

  • \u2022 Logged in as a user with sudo privileges .
    \u2022<\/b> Installing a LAMP stack on your CentOS 7 server\u2014Linux, Apache, MariaDB, and PHP\u2014is the second need that must be met before beginning this instruction. This is the system we’ll employ to provide our phpMyAdmin interface (MariaDB is also the database management software that we are wishing to manage).
    \u2022 You can read the remainder of this page if you’ve followed these instructions and got your server up and running<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tStep :1 Install phpMyAdmin<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    The phpMyAdmin software installation may start right immediately because our LAMP platform is already set up. Unfortunately, CentOS 7’s default repository does not have phpMyAdmin.<\/p>

    We will have to add an additional repository to our system in order to receive the packages we require. The phpMyAdmin package we need can be found in the EPEL repo (Extra Packages for Enterprise Linux), among many other packages.<\/p>

    Installing the epel-release<\/strong> package will enable your server to access the EPEL repository. Your repository list will be updated as a result, and you’ll have access to the EPEL packages.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t# sudo yum install epel-release<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Once the EPEL repo is set up, you can use the yum<\/strong> packaging system to install the phpMyAdmin package by typing:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t # sudo yum install phpmyadmin<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Now the installation is finished. An Apache configuration file that has already been set up was provided in the installation. To make this work properly for our installation, we will need to make a few modifications.<\/p>

    Now that the file is open in your text editor, let’s make some changes:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t# sudo vi \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    To describe the access policy for our directory, we can see several directory blocks within with some conditional logic. There are two defined directories that include settings that are appropriate for both Apache 2.2 and Apache 2.4. (which we are running).<\/p>

    This configuration currently forbids access to any connection that is not coming from the server. We need to change a few lines to give the IP address of your home connection because we’re working on our server remotely.<\/p>

    Any lines that say Require ip 127.0.0.1<\/strong> or Allow from 127.0.0.1<\/strong> should be changed to refer to the IP address of your home connection. Check out the next section if you need assistance locating the IP address of your home connection. The file should need to be modified in the following four places:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    . . .<\/strong>
    Require ip your_workstation_IP_address<\/strong>
    . . .<\/strong>
    Allow from your_workstation_IP_address<\/strong>
    . . .<\/strong>
    Require ip your_workstation_IP_address<\/strong>
    . . .<\/strong>
    Allow from your_workstation_IP_address<\/strong>
    . . .<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    When finished, type: to restart the Apache web server and apply your changes.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo systemctl restart httpd.service<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Our phpMyAdmin installation is now operating as a result. Use your web browser to navigate to your server’s domain name or public IP address followed by \/phpMyAdmin <\/strong>to enter the interface:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\thttp:\/\/server_domain_or_IP\/phpMyAdmin<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Use a valid MariaDB user’s username and password to log in. A decent place to start is with the root <\/strong>user and the MariaDB administrator password. After that, you will have access to the administration interface:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tStep 2: Secure your phpMyAdmin instance.<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    At this point, the phpMyAdmin instance that was installed on our server ought to be fully functional. However, we have made our MySQL system accessible to the public by installing a web interface.<\/p>

    This is a big issue even with the built-in authentication screen. Installations like these are frequent targets for attackers due to the popularity of phpMyAdmin and the vast quantity of data it grants access to.<\/p>

    To reduce the likelihood that our installation may be compromised and targeted, we will put into practise two straightforward measures. To avoid some of the automated bot brute-force attacks, we will move the interface from \/phpMyAdmin<\/strong> to another site. Additionally, we’ll build a second, web server-level authentication gateway that needs to be passed in order to access the phpMyAdmin login page.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tChanging the Application\u2019s Access Location<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Our phpMyAdmin Apache configuration file uses an alias to route to the directory location of the files in order for our Apache web server to function with phpMyAdmin.<\/p>

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 We just need to rename the alias to change the URL where our phpMyAdmin interface may be accessed. Now, access the Apache configuration file for phpMyAdmin:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo nano \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    You will see two lines at the top of the file that look like this:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Alias \/phpMyAdmin \/usr\/share\/phpMyAdmin<\/strong>
    Alias \/phpmyadmin \/usr\/share\/phpMyAdmin<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    These two lines function as our aliases, which means that we will be shown the content at \/usr\/share\/phpMyAdmin<\/strong> if we approach our site using its domain name or IP address followed by either \/phpMyAdmin<\/strong> or \/phpmyadmin.<\/strong><\/p>

    Due to the fact that bots and malicious people frequently target certain particular aliases, we want to disable them. We should instead choose our own alias. It should be simple to recall but challenging to guess. It shouldn’t state what the URL location is for. In this instance, we’ll use \/nothingtosee.<\/strong><\/p>

    We should delete or comment out the current lines and add our own to implement the changes we intend:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    # Alias \/phpMyAdmin \/usr\/share\/phpMyAdmin<\/strong>
    # Alias \/phpmyadmin \/usr\/share\/phpMyAdmin<\/strong>
    Alias \/nothingtosee \/usr\/share\/phpMyAdmin<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Save your work and then exit the file.<\/p>

    Restart the web service to apply the changes:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo systemctl restart httpd.service<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    You will now encounter a 404 error if you attempt to access the former location of your phpMyAdmin installation:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\thttp:\/\/server_domain_or_IP\/phpMyAdmin<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    However, the new site we chose will now host your phpMyAdmin interface:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\thttp:\/\/server_domain_or_IP\/nothingtosee<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tA Web Server Authentication Gate's configuration<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    The next feature we needed for our installation was a login page for phpMyAdmin that would not be visible until a user had successfully passed an authentication check.<\/p>

    Thankfully, most web servers\u2014including Apache\u2014offer this functionality by default. Simply changing our Apache configuration file will enable us to use an authorization file.<\/p>

    Reopen the text editor and the phpMyAdmin Apache configuration file:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo nano \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    We need to add an override directive outside of any of the blocks inside the \/usr\/share\/phpMyAdmin<\/strong> directory block. It will seem as follows:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    <Directory \/usr\/share\/phpMyAdmin\/><\/strong>
    AllowOverride All<\/strong>
    <IfModule mod_authz_core.c><\/strong>
    . . .<\/strong>
    <\/Director. . .<\/strong>
    y><\/strong>
    . . .<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    This will enable us to put further configuration information in a file called .htaccess<\/strong> that is placed inside the phpMyAdmin directory. This file will be used to configure our password authentication.<\/p>

    When you’re done, save and shut the file.<\/p>

    To make this update effective, restart the web service:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo systemctl restart httpd.service<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    This will enable us to put further configuration information in a file called .htaccess<\/strong> that is placed inside the phpMyAdmin directory. This file will be used to configure our password authentication.<\/p>

    When you’re done, save and shut the file.<\/p>

    To make this update effective, restart the web service:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tCreate an .htaccess File<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Since we have included the override directive to our setup, Apache will now search the \/usr\/share\/phpMyAdmin<\/strong> directory for a file with the name .htaccess<\/strong>. If it does, it will add the directives in it to its prior configuration information.<\/p>

    The .htaccess<\/strong> file needs to be created in that directory as the following step. Use your text editor to do this right away:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\tsudo nano \/usr\/share\/phpMyAdmin\/.htaccess<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    We must enter the following details in this file:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    AuthType Basic<\/strong>
    AuthName “Admin Login”<\/strong>
    AuthUserFile \/etc\/httpd\/pma_pass<\/strong>
    Require valid-user<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Let’s discuss the meaning of each of these lines:<\/p>

    • AuthType Basic<\/strong>: This line describes the type of authentication that we are using. This kind will use a password file to implement password authentication.<\/li>
    • AuthName<\/strong>: This configures the authentication dialogue box’s message. Keep this general to prevent unauthorised users from learning what is being protected.<\/li>
    • AuthUserFile<\/strong>:\u00a0This configures the authentication dialogue box’s message. Keep this general to prevent unwanted users from learning what is being protected.<\/li>
    • Require valid-user<\/strong>: This states that this resource should only be accessible to people who have provided valid credentials. This is what truly prevents entry by unauthorised users.<\/li><\/ul>

      Save the file after you have completed entering this information.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\tMake the authentication password file.<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      Now that the AuthUserFile <\/strong>directive in our .htaccess<\/strong> file has indicated the path for our password file, we need to build and populate the password file.<\/p>

      Htpasswd i<\/strong>s a tool provided by Apache that can be used to achieve this. The location where we want to create the file and the username we want to add authentication information for are passed to the command when we run it:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\tsudo htpasswd -c \/etc\/httpd\/pma_pass username<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      The -c parameter signals that an initial file will be created. The path and filename for the file will be determined by the directory location. The first user we want to add is the username. You will be asked to enter and verify the user’s password.<\/p>

      You may run the same command again with a different username and without the -c parameter if you wish to add other users to authenticate:<\/p>

      The -c parameter signals that an initial file will be created. The path and filename for the file will be determined by the directory location. The first user we want to add is the username. You will be asked to enter and verify the user’s password.<\/p>

      You may run the same command again with a different username and without the -c parameter if you wish to add other users to authenticate:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\tsudo htpasswd \/etc\/httpd\/pma_pass seconduser<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      We now get a password prompt when we visit our site once our password file has been produced and an authentication gateway has been put in place:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\thttp:\/\/server_domain_or_IP\/nothingtosee<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      The standard phpMyAdmin login page will be displayed when you have entered your credentials. In addition to the increased security, this extra layer of security will assist in preventing authentication attempts from appearing in your MySQL logs.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\tConclusion<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      Now, you can administer your MySQL databases using a web interface that is largely safe. The majority of the functionality accessible via the MySQL command prompt is exposed by this UI. You can run queries, view databases and schema, and build new data sets and structures.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","manualknowledgebasecat":[20],"manual_kb_tag":[],"class_list":["post-3572","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-knowledgebase"],"yoast_head":"\nHow to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services\" \/>\n<meta property=\"og:description\" content=\"Introduction A sizable percentage of websites and applications use relational database management systems like MySQL and MariaDB. While using the command line to manage their data may not be comfortable for all people. In order to provide a solution in the form of a web-based management interface, a project named phpMyAdmin was developed. We’ll show […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostzop - Web Hosting Services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hostzop\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-01T07:48:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2022\/12\/login.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@hostzop\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/\",\"name\":\"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/login.png\",\"datePublished\":\"2022-12-05T06:38:35+00:00\",\"dateModified\":\"2023-02-01T07:48:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/login.png\",\"contentUrl\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/login.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\",\"name\":\"hostzop.com\\\/knowledge\\\/\",\"description\":\"Just another WordPress site\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#organization\",\"name\":\"Hostzop knowledge\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.png\",\"width\":233,\"height\":103,\"caption\":\"Hostzop knowledge\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hostzop\\\/\",\"https:\\\/\\\/x.com\\\/hostzop\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/","og_locale":"en_US","og_type":"article","og_title":"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services","og_description":"Introduction A sizable percentage of websites and applications use relational database management systems like MySQL and MariaDB. While using the command line to manage their data may not be comfortable for all people. In order to provide a solution in the form of a web-based management interface, a project named phpMyAdmin was developed. We’ll show […]","og_url":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/","og_site_name":"Hostzop - Web Hosting Services","article_publisher":"https:\/\/www.facebook.com\/hostzop\/","article_modified_time":"2023-02-01T07:48:25+00:00","og_image":[{"url":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2022\/12\/login.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@hostzop","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/","url":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/","name":"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache - Hostzop - Web Hosting Services","isPartOf":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/#primaryimage"},"image":{"@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/#primaryimage"},"thumbnailUrl":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2022\/12\/login.png","datePublished":"2022-12-05T06:38:35+00:00","dateModified":"2023-02-01T07:48:25+00:00","breadcrumb":{"@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/#primaryimage","url":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2022\/12\/login.png","contentUrl":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2022\/12\/login.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-set-up-and-secure-phpmyadmin-on-a-centos-7-server-using-apache\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hostzop.com\/knowledge\/"},{"@type":"ListItem","position":2,"name":"How to Set Up and Secure phpMyAdmin on a CentOS 7 Server Using Apache"}]},{"@type":"WebSite","@id":"https:\/\/www.hostzop.com\/knowledge\/#website","url":"https:\/\/www.hostzop.com\/knowledge\/","name":"hostzop.com\/knowledge\/","description":"Just another WordPress site","publisher":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostzop.com\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hostzop.com\/knowledge\/#organization","name":"Hostzop knowledge","url":"https:\/\/www.hostzop.com\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hostzop.com\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2023\/02\/logo.png","contentUrl":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2023\/02\/logo.png","width":233,"height":103,"caption":"Hostzop knowledge"},"image":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hostzop\/","https:\/\/x.com\/hostzop"]}]}},"_links":{"self":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb\/3572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/comments?post=3572"}],"version-history":[{"count":0,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb\/3572\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/media?parent=3572"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manualknowledgebasecat?post=3572"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb_tag?post=3572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}