Install PHP, the PHP Extension and Application Repository, Apache support, and MySQL support: sudo apt install php libapache2-mod-php php-mysql ![]() Install the mysql-server package: sudo apt install mysql-server Install Apache 2.4 from the Ubuntu repository: sudo apt install apache2 The following steps can be used on Ubuntu 20.04 to install all of the required prerequisite software: The three pieces of software required are also commonly referred to as a LAMP stack. In order to install and secure phpMyAdmin, you need to have a Linux server with the following services running: Search for objects in databases and tables.Create, modify and remove databases, tables, rows and fields.Create, modify and remove users and user permissions.These are some of the core features of phpMyAdmin: It is therefore a vital component to secure given the nature of data it is used to create and manage. PhpMyAdmin is widely adopted and used in both production and development environments by developers and system administrators. It makes the process of creating, modifying and configuring MySQL databases simpler and much more efficient. ![]() You don’t want those credentials going through the wire in plain text, so in the next tip we will explain how to setup a self-signed certificate for PhpMyAdmin login page.PhpMyAdmin is a free, open source, and cross platform PHP-based web application that offers a simple, powerful and convenient browser based GUI for interacting and working with MySQL databases. Secure PhpMyAdmin Login Pageĭo not login using the database root user’s credentials yet. ![]() It should open the phpmyadmin interface (as shown in the image below), whereas should result in a Not Found error page. Now we need to change the URL of our phpMyAdmin page, we simply need to rename the symbolic link as shown: # cd /usr/share/nginx/htmlįinally, restart Nginx and PHP-FPM to apply changes and point your browser to - On CentOS/RHEL and Fedora. # ln -s /usr/share/phpmyadmin /usr/share/nginx/html usr/share/nginx/html) by typing the following command: # ln -s /usr/share/phpMyAdmin /usr/share/nginx/html On the Nginx web server, we just need to create a symbolic link of PhpMyAdmin installation files to our Nginx document root directory (i.e. # echo "Include /etc/phpmyadmin/nf" > /etc/apache2/nfįinally, restart Apache to apply changes and point your browser to - On CentOS/RHEL and Fedora. In addition, make sure Apache reads the phpmyadmin configuration in Debian/Ubuntu: - On Debian and Ubuntu. In the same file, make sure the Require all granted directive is included inside the Directory /usr/share/phpmyadmin block. The above will allow us to access the phpmyadmin interface via Feel free to change the Alias above if you want to use another URL. Then add a new one as follows: # Alias /phpmyadmin /usr/share/phpmyadmin Open /etc/httpd/conf.d/nf if in CentOS or /etc/phpmyadmin/nf in Debian and comment out the line(s) beginning with Alias. To do it in Apache or Nginx Web servers, follow the instructions as explained below: Change PhpMyAdmin Login Page in Apache Note: Make sure you have working LAMP or LEMP setup with PhpMyAdmin installed on your system, if not, then follow Setup LAMP or LEMP with PhpMyAdmin. This is known as security through obscurity and while some people would argue that it is not a safe measure, it has been known to both discourage attackers and to prevent break-ins. This will not necessarily stop attackers from targeting your server, but will lower the risks of a successful break-in. By default, the login page of phpmyadmin is located at The first thing that you will want to do is changing that URL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |