Cara menggunakan phpmyadmin not found ubuntu

The phpMyAdmin utility is a web-based graphical database management tool. By installing phpMyAdmin, you no longer need to use the default command-line interface to manage databases.

This guide will shows you how to lay the groundwork and install phpMyAdmin on Debian 11.

Tutorial on how to Install phpMyAdmin on Debian 11

Prerequisites

  • Debian 11 installed and running.
  • A user account with sudo or root privileges.
  • Access to a terminal window/command line.

Step 1: Install LAMP Stack on Debian 11

phpMyAdmin requires the LAMP stack to work correctly. This section shows you how to install the supporting software to turn your Debian 11 system into a web server.

If you already have a LAMP stack installed, you can skip directly to the section.

Step 1.1: Update Software Packages and Install wget

Open a terminal window and update your software package lists with the following command:

sudo apt update

Enter the following command to install the wget tool:

sudo apt install wget -y

The wget utility allows you to download files directly from the terminal window.

You now have the tools to install a LAMP stack and phpMyAdmin.

Step 1.2: Install Apache

Apache is a web server software that processes requests and transmits data over an HTTP network. Install Apache by entering the following command in the terminal:

sudo apt install apache2 -y

The process takes a few moments to complete. Enter the following command to confirm the Apache service is running:

systemctl status apache2

The report shows a green status message that says active (running).

Status of Apache web server on Debian 11.

Press 

sudo apt install apache2 -y
6 to return to the command prompt.

Step 1.3: Install PHP on Debian 11

The PHP programming language and coding environment are essential for running a web application like phpMyAdmin. Install core PHP packages and Apache and MySQL plugins with the following command:

sudo apt -y install php php-cgi php-mysqli php-pear php-mbstring libapache2-mod-php php-common php-phpseclib php-mysql

Once the installation process is complete, verify that PHP has been installed:

php --version

The system displays the current PHP version along with the release date.

The version of PHP currently installed on Debian 11.

Step 1.4: Install and Set Up MariaDB on Debian 11

This guide uses the MariaDB open-source relational database management system instead of MySQL. MariaDB and MySQL are compatible, and many commands and features are identical.

To install MariaDB, enter the following command:

sudo apt install mariadb-server mariadb-client -y

Once the process is complete, verify the MariaDB installation:

systemctl status mariadb

Like with Apache, you see an active (running) status.

System confirms that the MariaDB service is active and running on Debian 11.

Before installing phpMyAdmin, you need to configure the MariaDB database.

Secure MariaDB

Configure basic MariaDB security features by launching a built-in script:

sudo mysql_secure_installation

As you have not yet set a root password for your database, hit Enter to skip the initial query. Complete the following queries:

  • Switch to unix_socket authentication [Y/n] - Enter n to skip.
  • Set root password? [Y/n] - Type
    sudo apt install apache2 -y
    7 and press Enter to create a strong root password for your database. If you already have a root password, enter n to answer the Change the root password question.
  • Remove anonymous users? [Y/n] - Type
    sudo apt install apache2 -y
    7 and press Enter.
  • Disallow root login remotely? [Y/n] - Type
    sudo apt install apache2 -y
    7 and press Enter.
  • Remove test database and access to it? [Y/n] - Type
    sudo apt install apache2 -y
    7 and confirm with Enter.
  • Reload privilege tables now? [Y/n] - Type
    sudo apt install apache2 -y
    7 and confirm with Enter.

The output shows the MariaDB installation is now secure.

screenshot showing you have successfully secured the MariaDB installation on Debian 10

Create a New MariaDB User

The phpMyAdmin utility needs a designated user to connect to your database. Creating a new MariaDB user improves security and allows you to control the level of permissions granted to this user.

Use our detailed guide to create a new MariaDB user and grant privileges. Once you set up a MariaDB user, start the phpMyAdmin installation process.

Step 2: Download phpMyAdmin

Use the

systemctl status apache2
2 command to retrieve the latest stable version of phpMyAdmin:

wget -P Downloads https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz

To download the English version only, use this command instead:

sudo apt install wget -y
0

The

systemctl status apache2
3 option instructs
systemctl status apache2
2 to save the files directly in the Downloads directory. Use any directory to download the file and remember the path.

phpMyAdmin downloading in Debian 11

Note: To download a specific version, or to check the latest version, please refer to the developer’s phpMyAdmin page.

Step 3: Check phpMyAdmin GPG Key

Each downloaded archive has a corresponding .asc file that contains its unique key signature. Once both files are in the same folder, the signature can be verified.

1. To verify the GPG key for phpMyAdmin, download the phpMyAdmin keyring to the directory you used previously. In our case Downloads:

sudo apt install wget -y
1

2. Access the Downloads directory and import the keyring:

sudo apt install wget -y
2
sudo apt install wget -y
3

System imports gpg keyring to verify phpmyadmin download files

3. Download the corresponding GPG .asc file for your version of phpMyAdmin and stay in the same directory:

sudo apt install wget -y
4

4. Stay in the same directory (in our case Downloads) and verify the .asc file against the keyring you downloaded:

sudo apt install wget -y
5

The system responds by displaying GPG key information.

Output with the GPG key that verifies the downloaded files

You can now compare the GPG key to the developer credentials on the .

Step 4: Unpack and Configure phpMyAdmin

1. Create a phpMyAdmin directory in the Apache web root directory:

sudo apt install wget -y
6

2. Access the Downloads directory and unpack the phpMyAdmin tar.gz files to the newly created directory:

sudo apt install wget -y
7

The terminal shows no response when the file is unpacked.

3. Create a default configuration file:

sudo apt install wget -y
8

4. Use the nano text editor (or your preferred text editor) to add a secret passphrase to the config.inc.php file:

sudo apt install wget -y
9

Locate the following line:

sudo apt install apache2 -y
0

Add passphrase to the phpmyadmin config file.

Add a secret passphrase between the single quotes. For example:

sudo apt install apache2 -y
1

Use a complex passphrase of your choice and then exit and save the file (

systemctl status apache2
5).

5. Change the permissions for the config.inc.php file:

sudo apt install apache2 -y
2

6. Change ownership of the phpMyAdmin directory:

sudo apt install apache2 -y
3

7. Restart Apache:

sudo apt install apache2 -y
4

Step 5: Access phpMyAdmin from Browser

Use a web browser and navigate to the localhost/your_phpMyAdmin_directory adress to access phpMyAdmin. In our case:

sudo apt install apache2 -y
5

The system shows the phpMyAdmin login screen and establishes a connection to the local Apache, MariaDB, and PHP files that you have created.

phpMyAdmin login page Debian 11

Log in to phpMyAdmin with the username and password for the MariaDB user you had created.

Conclusion

You have now installed phpMyAdmin on your Debian 11 system. Access the GUI from a browser and start administering your databases more efficiently.