Konfigurasi DATABASE SERVER Pada OS Debian 10 | VirtualBox

Summary

This tutorial guides users through the process of installing and configuring essential web services on Debian OS, including Apache, PHP, MariaDB, and PhpMyAdmin. It covers the setup of a virtual machine, network configuration, and step-by-step instructions for installing and configuring each service. The tutorial also shows how to create a new user, grant privileges, and manage databases through PhpMyAdmin. It’s designed for users looking to set up a fully functioning web server and database management system on Debian 9 and 10, with clear instructions for testing and troubleshooting along the way.

Takeaways

• 😀 Ensure you have two ISO files: Debian 10 and Debian 9, as PHPMyAdmin is not available in Debian 10 by default.
• 😀 Set up a virtual machine and install Debian with proper network settings and updates.
• 😀 Log in as root and configure the system by adding source files from the Debian ISOs for package installation.
• 😀 Test network connectivity by setting up a static IP address and verifying the connection using the ping command.
• 😀 Install the Apache web server and configure the Apache configuration file, specifying a DNS name like 'www.tkc.co.id'.
• 😀 Check if the Apache web server is running by testing it on the browser with the DNS address.
• 😀 Install PHP 7.3 and test the PHP functionality by creating a file to check if PHP is working properly.
• 😀 Install MariaDB server and PHPMyAdmin using the necessary ISOs, and configure them according to the instructions.
• 😀 Use MySQL commands to create a new user with appropriate privileges for managing databases.
• 😀 Set up root access in PHPMyAdmin by configuring MySQL root user credentials and enabling root login through the web interface.
• 😀 Test the PHPMyAdmin interface by logging in as root and creating a new database, ensuring full access and functionality.

Q & A

What are the two ISO files required for this installation?

You need two ISO files: one for Debian 10 and one for Debian 9. These are necessary because Debian 10 lacks the phpMyAdmin service, which is available in Debian 9.

What should you do if you encounter issues with network configuration during the installation?

You should verify the network interface settings by running the `ip addr` command to check the interface. Then, configure the static IP address by editing the `/etc/network/interfaces` file. Ensure that the VM and the host machine are on the same network.

How can you check if Apache has been installed successfully?

After installing Apache with `apt install apache2 -y`, you can check its status using `systemctl status apache2`. Additionally, you can verify by opening a web browser and navigating to your server's IP address, where you should see the Apache default page.

What is the purpose of editing the `000-default.conf` file in Apache configuration?

The `000-default.conf` file is used to configure the server settings. By uncommenting and setting the `ServerName` directive, you can specify your server’s domain or IP address, making it easier to access the web server using a hostname.

How can you test PHP installation on your server?

You can test PHP by creating a file named `info.php` in the `/var/www/html/` directory with the content `<?php phpinfo(); ?>`. Then, open this file in a web browser (e.g., http://yourIP/info.php) to see if PHP is properly installed.

What steps are involved in securing the MariaDB installation?

To secure MariaDB, run `mysql_secure_installation` after installing MariaDB. This will prompt you to set a root password, remove anonymous users, disallow remote root login, and remove test databases, ensuring a more secure environment.

What is the purpose of installing phpMyAdmin?

phpMyAdmin is a web interface for managing MySQL or MariaDB databases. By installing phpMyAdmin, you can easily perform database operations such as creating, deleting, and managing databases without needing to use the command line.

What is the significance of the `GRANT ALL PRIVILEGES` command in MySQL?

The `GRANT ALL PRIVILEGES` command is used to give a user full access to the databases. This is essential when creating a new user who needs administrative rights to perform actions like creating or modifying databases.

Why should you test your configuration after installing all services?

Testing is crucial to ensure that all installed services, such as Apache, PHP, and MySQL/MariaDB, are running correctly and communicating with each other. It helps identify and troubleshoot any issues early on.

What should you do if the phpMyAdmin login page doesn't appear?

If phpMyAdmin doesn't appear, you may need to check the Apache configuration, ensure that phpMyAdmin is properly installed, and verify that the correct services (Apache, PHP, MySQL) are running. Additionally, check the web server logs for any errors.