With phpMyAdmin, you can easily manage your MySQL and MariaDB databases through a web-based interface, greatly simplifying database management tasks.Īlways remember that the phpMyAdmin interface should be protected since it can be a potential security risk if not properly secured. ConclusionĬongratulations, you have successfully installed and configured phpMyAdmin on your Debian server.

If you’re able to create, view, and delete a database, it indicates that phpMyAdmin has been set up correctly. To test if phpMyAdmin is working correctly, try creating a new database. Enter the username and password for the MySQL account you want to use, and you’re in! You will be presented with the login screen. Just type in your browser, replace ‘your_server_ip’ with the actual IP of your server. Save and close the file.įinally, restart Apache again: sudo systemctl restart apache2 Step 5: Access phpMyAdminĪfter completing the installation and setup, you can now access phpMyAdmin through your web browser. To restrict access, edit the Apache configuration file for phpMyAdmin: sudo nano /etc/apache2/conf-available/nfįind the line that reads and underneath it, add the line Require ip your_server_ip, replacing ‘your_server_ip’ with your actual server IP address. However, this is not safe, and it is recommended to restrict the IP addresses that can access phpMyAdmin. Then, you’ll need to restart the Apache service to apply the changes: sudo systemctl restart apache2 Step 4: Secure Your phpMyAdmin Instanceīy default, phpMyAdmin can be accessed from any IP address. Enable them by typing: sudo phpenmod mbstring sudo phpenmod mysqli PhpMyAdmin requires several PHP extensions to function correctly. Set a strong password and remember it.Įnter MySQL root user password required by the installer to create new user and database. Next, you will be asked to set a password for phpMyAdmin to register with the database. The installer will then prompt you to configure the database for phpMyAdmin with ‘dbconfig-common’. Use the following command to install phpMyAdmin: sudo apt-get install phpmyadminĭuring the installation process, you will be asked to choose the web server to configure. Once your system is up-to-date, you can install phpMyAdmin. Open your terminal and execute the following command: sudo apt-get update -y sudo apt-get upgrade -y Step 2: Install phpMyAdmin on Debian Step 1: Update Your Systemįirstly, you need to update your system to ensure that all the packages on the server are up-to-date. It provides a graphical interface, making it easier to manage, create, and modify databases, tables, fields, etc.īefore we start, please ensure you have administrative access to the Debian system and that the LAMP (Linux, Apache, MySQL/MariaDB, PHP) stack is installed on your server. phpMyAdmin is a web-based application used for managing MySQL and MariaDB databases. This article is a step-by-step guide on how to install and configure phpMyAdmin on a Debian operating system.

Debian 9 phpmyadmin password