![]() In this article, we have seen how our support engineers install Apache, MariaDB, PHP, and phpMyAdmin in Ubuntu 18.04 server. Now, we can log in to phpMyAdmin using the admin user. MariaDB > GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION To create a new user, login into MariaDB using the following command: We need to create a new user and grant all privileges to that user. Once everything installed, you can now restart the apache2 service to effect the recent changes. Next, enter the password for the MySQL/MariaDB administrative user so the installer can create a database for phpmyadmin. Through the package installation process, you will be asked to choose the web server that should be automatically configured to run phpMyAdmin, select apache by pressing the space bar and press Enter. You can install phpMyAdmin for administrating MySQL/MariaDB databases from the comfort of a web browser using the following command: Now, let’s access it from the web browser: # echo “” | sudo tee /var/www/html/info.php Once PHP installed, for testing purpose, create a simple info.php page using following command: # apt install php php-common php-mysql php-gd php-cli -y Here we are installing the default PHP version 7.2 and other modules for web deployments using the following command: Remove test database and access to it? : y Then enter yes/y to the following security questions: It will ask you to enter the current password for root (enter for none): Step 1: Login via SSH Login to your Ubuntu 16. Once the script gets executed, it will ask multiple questions. Let’s secured the installation using the following command: The default configuration of the MariaDB will not be secured. # apt install mariadb-server mariadb-client -y Now, let’s verify the Apache installation. In case, you enabled firewall and firewall block requests of the apache web server, open a port in the firewall. ![]() ![]() It is known as LAMP and installs on the Linux system environment. With this we end our tutorial on how to install phpMyAdmin on Ubuntu, please feel free to mention your queries/questions in the comment box below.In this article, we will learn to install Apache, MariaDB, PHP, and PHPMyAdmin in Ubuntu 18.04 server.Īpache, MySQL/MariaDB, and PHP are composed of packages. ![]() So just install the other required packages to run and access phpMyAdmin. Now restart the apache service, after which phpMyAdmin interface will only be accessible from mentioned IP address & will be blocked to rest. Step 1 Install Apache and PHP We are assuming you already have installed the MySQL server on Ubuntu system. Where 123.45.67.89 is the public ip address for the network we need access from. htaccess’ file (located at the root of the website directory) In order to do that we will make the following entry to ‘. Suppose we have only one location which uses phpMyAdmin to administer databases, so we should allow access to only that site. To install Apache on the Ubuntu server, run the commands below. Second thing, we can do secure phpMyAdmin is to make it accessible from one or limited number of IP address/location. Step 1 Installing phpMyAdmin You can use APT to install phpMyAdmin from the default Ubuntu repositories. How to install Apache on Ubuntu Linux phpMyAdmin needs a web server to function, and Apache HTTP Server is a great open-source server that you can use with phpMyAdmin. If you need help in securing website with an SSL certificate, refer to following articles Secure your website with SSL sha2 certificate, Learn to create SSL Certificate for Apache Server. So it is essential to secure it, otherwise we might loose important data.įirst thing we should do secure phpMyAdmin is that we need to use SSL certificate to encrypt all website communication. With the kind of functionalities that phpMyAdmin provides, it is one of the most targeted service on internet.
0 Comments
Leave a Reply. |