How to install PHPMyAdmin in Kali Linux and Debian

Hello everyone! We will study how to install PHPMyAdmin in Kali Linux and Debian. It works on Ubuntu, Debian distributions, Linux Mint, Kubuntu, and all Debian-like operating systems. If you have a new Kali Linux system, read our “Ten Things You Must Do After Installing Kali Linux” tutorial. If you have an Ubuntu system, please check the operation after installing Ubuntu 14.04, 12.04, 13.0.

What is PHPMyAdmin?

PHPMyAdmin is a free software tool written in PHP designed to handle MySQL administration through a web interface. phpMyAdmin supports multiple operations on MySQL, MariaDB and Drizzle. You can perform common operations (manage databases, tables, columns, relationships, indexes, users, permissions, etc.) through the user interface, while you can still execute any SQL statement directly.

The function of PHPMyAdmin is

  • Intuitive cool web interface
  • Supports most MySQL features
  • Import data from CSV and SQL
  • Export data to multiple formats: CSV, SQL, XML, PDF, ISO / IEC 26300-OpenDocument text and spreadsheets, Word, LATEX, etc.
  • Manage multiple servers
  • Create PDF graphics for database layout
  • Create complex queries using sample queries (QBE)
  • Global search in the database or its subset
  • Convert stored data to any format using a set of predefined functions, such as displaying BLOB data as images or download links

Following is the process to follow when installing PHPMyAdmin in Kali Linux.

prerequisites:

Install Apache web server and MySQL

$ sudo apt-get update
$ sudo apt-get install apache2
$ sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

Activate MySQL using the following command:

$ sudo mysql_install_db

This is done by running the MySQL setup script:

$ sudo /usr/bin/mysql_secure_installation

Install PHP:

sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt

The next thing to do is reset the mysql password. Mysql and Debian-derived versions of Kali Linux come with passwords. We must reset this password and set our own password. Use the following command:

su - 
sudo /etc/init.d/mysql stop
mysqld_safe --skip-grant-tables

Open another terminal in a new window and type the following command
Note: Remember to replace “new-password” with the password for which you want to use PHPMyAdmin and the MySQL root login.
Then enter:

su -
mysql -u root
use mysql;
update user set  password=PASSWORD("new-password") where User='root';
flush privileges;
quit

The next step is to restart MySQL. Use the following command:

/etc/init.d/mysql stop
/etc/init.d/mysql start

Test to see if MySQL is now using your new password and username root:

mysql -u root -p

If you don’t need the latest version, now we must install PHPMyAdmin

sudo apt-get install phpmyadmin
sudo ln -s /usr/share/phpmyadmin/  /var/www/phpmyadmin

You can install it by downloading the latest phpMyadmin from the link below: PHPMYADMIN homepage

Unzip the downloaded file and copy it to the / usr / share folder. Then create a symbolic link by typing:

sudo ln -s /usr/share/phpfolder/ /var/www/phpmyadmin

Start PHPMyAdmin

sudo service apache2 start && service mysql start

Launch your favorite browser and enter:

localhost/phpmyadmin

Login with root and password.

How to install PHPMyAdmin in Kali Linux and Debian

Search tags:
How to install MySQL in Kali Linux and Ubuntu
How to install PHPMyAdmin
How to install PHPMyAdmin in Kali Linux and Debian
Get PHPMyAdmin Windows Windows Powershell commands running on Debian and Kali Linux on demand

Sidebar