Now we need to specify the username and followed by a colon (:), followed by the encrypted version of the password that we generated during the encrypted password creation process using the openssl passwd. We will call this file pma_pass and we need to save it inside the Nginx configuration directory: sudo vim /etc/nginx/pma_pass Now, create web server authentication gate credential file. Later, we would require this password while creating web server authentication gate credential file. Once you are done, you will be displayed an encrypted version of the password that will look like something this: zV.cjsFPfRQ6gĬopy this encrypted password in a notepad. Now, you will be asked to enter the password that you need to confirm to use. So, to create an encrypted password, run the following command: openssl passwd OpenSSL suite, which is already installed on your server, includes this functionality. Nginx needs that passwords in encrypted form using the crypt() function. We just require modifying the configuration file of the Nginx web server.īefore we do this, we need to create a password file that will store the web server authentication gate credentials. In most of the web servers, this capability is natively available which includes Nginx as well. Prompt that a user would be required to pass even before seeing the phpMyAdmin login screen. Web server authentication gate is a feature that enables authentication. Now, if try to navigate to the previous phpMyAdmin directory location, you will get a 404 error: Lrwxrwxrwx 1 root root 18 Apr 6 15:40 anonymous -> /usr/share/phpmyadmin Now, you will notice that the symbolic link name has changed: total 188 Once you are done, run the following command: ls -l To create a symbolic link with this name, run the following command: sudo mv phpmyadmin anonymous To do that let’s pick a new name for our symbolic link. This will change the access location of PHPMyAdmin. ![]() We can change this symbolic link to some other name or location that we would like to. If we look at line 4, we can clearly identify that we have a symbolic link i.e, PHPMyAdmin in this directory. ![]() Lrwxrwxrwx 1 root root 18 Apr 6 15:37 phpmyadmin -> /usr/share/phpmyadmin The output goes something like this: total 188 To know what exactly we are doing, let’s navigate to the Nginx document root directory: cd /var/www//public_html ls -l Now, we need to rename the symbolic link to change the access location of the web application from where the graphical user interface (GUI) of PHPMyAdmin can be accessed. Changing the Application’s Access Location You can add the following line under the Server(s) configuration section: $cfg = 'true' 3. You can use your phpMyAdmin to use SSL in phpMyAdmin configuration file, which is present inside /etc/phpmyadmin/ directory. htaccess file inside the PHPMyAdmin directory. This will allow specified IP addresses to access it. After that, you can follow through the rest of the steps to set passwords. If you have multiple web server installed, you can choose the best-suited web server as per your need and deployment. Select the installed web server on your Ubuntu. You will be asked for the server for which you want phpMyAdmin automatically configure. To pull down the required files and proceed with the installation, the apt packaging system can be used: sudo apt-get install phpmyadmin To get started, install phpMyAdmin from the default repositories of Ubuntu. Now restart your Apache Server by executing the following command: sudo service apache2 restart How to Install PHPMyAdmin on Ubuntu? Update your system sudo apt-get update & sudo apt-get upgrade -y Install the mcrypt PHP module sudo apt-get install mcrypt Hostname -f: This command shows your fully qualified domain name (FQDN). Hostname: This command shows your hostname. Now, check hostname and Fully Qualified Domain Name (FQDN).
0 Comments
Leave a Reply. |