Now that phpMyAdmin is installed, open its main configuration file and make the highlighted changes below. STEP 3: ADD APACHE2 PASSWORD AUTHENTICATION Again, no extra security, anyone can just browse there and attempt to login. You should see the default login page for the app. Type it to continue.Īfter the installation, you should be able to go to the server host name or IP followed by phpmyadmin/ You’ll then be prompted for the root password for MySQL/MariaDB. You should also be asked if you want to configure database for phpmyadmin with dbconfig-common, then the tab key and press enter to continue. It works with Apache2, Nginx webservers and MySQL and MariaDB database servers and PHP.įor this post, we’re going to be using Apache2, MySQL/MariaDB and PHP or the LAMP stack on Ubuntu 17.04/17.10.Īfter installing LAMP, run the commands below to install phpMyAdmin sudo apt-get updateĭuring the installation, you’ll be prompted to choose a webserver to use with phpMyAdmin. To setup phpMyAdmin with Apache2 password authentication, continue with the steps below: STEP 1: INSTALL LAMPįirst, understand that phpMyAdmin requires that you have a webserver, database servers and PHP to function. This is a great way to filter out legitimate users verses those who want to access the site and cause trouble. Doing this will only allow folks who are authenticated via Apache2 to continue to phpMyAdmin logon age. If you want to add additional protection, create a separate layer of authentication using Apache2 htpassword module. By default when you install phpMyAdmin it will allow anyone to sign on using the root account created from anywhere. Now log in to PhpMyAdmin with the required database username and password.This brief tutorial is going to show students and new users how to easily install phpMyAdmin and password protect its logon page. Open the browser and enter the target system IP address along with the PhpMyAdmin file to run the application. Php-mysql php-pear php-php-gettext php-phpseclib php-tcpdf php-xml php-zip php7.0-bz2 php7.0-curl php7.0-gd php7.0-mbstring php7.0-mcrypt php7.0-mysql php7.0-xmlĭbconfig-common: flushing administrative passwordĪpache2_invoke: Enable configuration phpmyadmin :~# apt-get install phpmyadmin -yĭbconfig-common dbconfig-mysql javascript-common libjs-jquery libjs-sphinxdoc libjs-underscore libmcrypt4 libzip4 php-bz2 php-curl php-gd php-mbstring php-mcrypt Now install the PhpMyAdmin package and press y to continue with the installation procedure. The Apache and MySQL services are running without any glitches. Synchronizing state of rvice with SysV service script with /lib/systemd/systemd-sysv-install.Įxecuting: /lib/systemd/systemd-sysv-install enable mysql? Synchronizing state of rvice with SysV service script with /lib/systemd/systemd-sysv-install.Įxecuting: /lib/systemd/systemd-sysv-install enable apache2 Start and enable Apache and MySQL service by running the following commands. The PhpMyAdmin package has been installed successfully. Processing triggers for systemd (232-21ubuntu2). Processing triggers for ureadahead (0.100.0-19). Processing triggers for libc-bin (2.24-9ubuntu2). Php7.0-json php7.0-opcache php7.0-readlineĪpache2-doc apache2-suexec-pristine | apache2-suexec-custom php-pear libipc-sharedcache-perl mailx tinyca Libhtml-template-perl liblua5.2-0 mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7 php-common php7.0 php7.0-cli php7.0-common The following additional packages will be installed:Īpache2-bin apache2-data apache2-utils libaio1 libapache2-mod-php7.0 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libevent-core-2.0-5 :~# apt-get install apache2 mysql-server php -y Install the LAMP server in the target system and press y to continue the installation process. The target system is updated with the required repositories.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |