Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Programming»PHP»How to Install and Configure phpMyAdmin on Debian 9/8

    How to Install and Configure phpMyAdmin on Debian 9/8

    By RahulApril 4, 20182 Mins Read

    phpMyAdmin is an open source tool widely used for the MySQL database administration. It provides an easy to use graphical user interface. You can easily create, modify, delete database and tables. It also allows managing user and permission. You can also configure database replication using phpMyAdmin.

    Advertisement

    This tutorial helps you to install and configure phpMyAdmin on a Debian 9 (Stretch) or Debian 8 (Jessie) system.

    Step 1 – Prerequsities

    You must fulfill followings:

  • This tutorial is tested for installing phpMyAdmin on Debian 9/8. It may be also used on Ubuntu systems
  • You must have Debian system root user access or sudo privileged user to accomplish this task.
  • You must have preconfigured LAMP stack on your server. You can use our tutorial to Setup LAMP on Debian 9 or Setup LAMP on Debian 8
  • Step 2 – Install phpMyAdmin on Debian

    First, update the Apt package manager cache on your Debian system to make the sure system have the latest version of packages.

    sudo apt-get update
    

    Now, Install phpMyAdmin by running the following command. This will also install required dependencies automatically.

    sudo apt-get install phpmyadmin
    

    The package configuration will ask for the basic configuration for phpMyAdmin. The first, you need to select web server to configure. This tutorial is using Apache web server.

    For this option click ok.

    Now select Yes for this option, let dbconfig-common create a database for phpMyAdmin.

    Set a password for the newly created user and database for phpMyAdmin. You can keep this filed blank to auto-generate password.

    Enter MySQL root user password required by the installer to create new user and database.

    Step 3 – Configure Apache for phpMyAdmin

    The phpMyAdmin setup is completed now. Just to make sure that phpmyadmin.conf is created under /etc/apache2/conf-enabled/ directory. Now you can access phpMyAdmin using system’s hostname or IP address.

    This requires MySQL username and password to login to phpMyAdmin.

    lamp MySQL PHP phpmyadmin PMA
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    Installing PHP on Pop!_OS

    How to Install PHP 8.x on Pop!_OS

    Managing Dependencies with Composer: A Beginner’s Guide

    (Resolved) MySQL connection error: certificate verify failed

    Add A Comment

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • 20 Basic Linux Commands for the Beginners (Recommended)
    • tail Command in Linux with Examples
    • What is a Orphan Process in Unix/Linux
    • How To Display Warning Message to Unauthorized SSH Access
    • How to Set a Custom SSH Login Banner and MOTD
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.