![]() ![]() But first, you need to set ownership of the directory to the logged-in ec2-user as follows: Next, create a custom directory for phpMyAdmin in the webroot directory. $ sudo yum update Step 2: Create a directory for phpMyAdmin To get started, ensure your system packages are updated as follows: Otherwise, your database administrator password and other data are transmitted insecurely across the internet.įor security recommendations from the developers, see “ Securing your phpMyAdmin installation.” Step 1: Update the system Note that we do not recommend using phpMyAdmin to access a LAMP server unless you have enabled SSL/TLS in Apache. A sudo user configured on your Amazon Linux 2 instance.We have already covered how to install the LAMP stack on Amazon Linux 2. In this guide, we will demonstrate how to install phpMyAdmin on Amazon Linux 2. For those who still prefer running commands, phpMyAdmin also includes a SQL editor for running SQL queries. It’s a feature-rich graphical tool that supports a wide selection of operations including creating and managing databases and tables, relationships, users, permissions, and more. This is where phpMyAdmin comes in.ĭeveloped in PHP, phpMyAdmin is a free and open source tool that simplifies the administration of MySQL or MariaDB over a web interface such as cPanel. However, if you are still developing database administration skills, you may prefer a more intuitive and visual platform for creating and managing databases. In this article, we have seen how our support engineers install Apache, MariaDB, PHP, and phpMyAdmin in Ubuntu 18.04 server.For seasoned system and database administrators, the command line is a comfortable and efficient way to run and administer various services and applications straight from the terminal. 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): 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. ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |