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.
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
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.
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
sudo service apache2 start && service mysql start
Launch your favorite browser and enter:
Login with root and password.
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