![]() To make it a virtualhost, add the following lines to the beginning of the file: ĬustomLog $/ combined: location and filename of custom logs.Įnable the newly created virtualhost using: sudo a2ensite nf Open the moved file for editing (I am using Nano editor here) sudo nano /etc/apache2/sites-available/nf To configure virtual host for phpMYAdmin, move the “nf” file to “/etc/apache2/sites-available/” directory using the command: sudo mv /etc/apache2/conf-enabled/nf /etc/apache2/sites-available/nf 127.0.0.1/phpmyadmin Configure VirtualHost for PhpMyAdminīy default, you can access PhpMyAdmin web interface via sub-directory, to access it via sub-domain, you have to configure the virtualhost for PhpMyAdmin. If you are running PhpMyAdmin on local Ubuntu 20.04 server, then type the following in your web browser’s address bar to access it. If you are using any application like WordPress on Ubuntu 20.04 server or have configured hostname for your server, then just add “/phpmyadmin” after your domain name. Restart the apache2 service for the changes to take effect. If the file is not automatically placed, then place it manually using the following command: sudo cp /etc/phpmyadmin/nf /etc/apache2/conf-enabled/nf When installing PhpMyAdmin in Ubuntu with apache webserver, a configuration file is placed at /etc/apache2/conf-enabled/nf which allows us to access PhpMyAdmin via sub-directory. sudo ufw allow 80,443/tcp Access PhpMyAdmin via sub-directory If you are using UFW firewall, then run the following command to open TCP port 80 and 443. ![]() Sudo iptables -I INPUT -p tcp -dport 443 -j ACCEPT sudo iptables -I INPUT -p tcp -dport 80 -j ACCEPT If you are using Iptables firewall, then run the following command to open both TCP port 80 and 443. To exit mariadb use: exit Configure Firewall for phpMyAdminīefore accessing phpMyAdmin, let’s make sure that the firewall is configured properly to avoid any unwanted interruptions. Select apache2 using space bar, when it prompts to select the webserver.Īs you can see, phpmyadmin has all privileges on database phpmyadmin. If you are using apache as your web server then, Install PhpMyAdmin in Ubuntu with all the package dependencies (including PHP 7 extensions) using the command: sudo apt install phpmyadminĭuring installation process, it will prompt you to configure some settings. – Sudo or root account access Install PhpMyAdmin in Ubuntu 20.04īefore proceeding with installation, it’s a good idea to update your software repositories using the command: sudo apt update How to Install LAMP Stack in Ubuntu 20.04? – LAMP Stack installed and running on Ubuntu 20.04Ĭheck the following post, if you have not setup LAMP stack yet. Pre-requisites to install phpMyAdmin in Ubuntu 20.04 (for example, displaying BLOB-data as image or download-link) Transform stored data into any format using a set of predefined functions.Search globally in a database or a subset of it.Creating graphics of database layouts in various formats.Export data to various formats: SQL, CSV, XML, PDF, Spreadsheet, Word.Manage user-account and privileges from its interface.Execute, edit or bookmark any SQL statement (Even execute multiple queries).Perform database and table maintenance.Create, copy, drop, rename and alter tables.Create, copy, drop, rename and alter databases.Intuitive and user-friendly web interface.PhpMyAdmin also offers a wide range of features to the administrators along with all the basic functions like managing databases, tables, users, permissions etc. PhpMyAdmin has well-maintained documentation with support for 72 languages (including both Right-to-left and Left-to-right languages). while also able to execute any SQL statement directly from its interface. Through this graphical tool, you can perform all the typical operations like managing databases, tables, users, permissions, columns, relations etc. In this post, I will show you how to install and secure phpMyAdmin in Ubuntu 20.04. PhpMyAdmin is an open-source web-based graphical tool written in PHP to manage MySQL or MariaDB database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |