How to Install MySQL Shell on Kali Linux

If you work with Kali Linux, sooner or later you will need a lightweight and reliable database for testing, training, security projects, or data storage. MySQL is a classic and reliable choice in this regard, I have done this installation and worked with MySQL in Kali several times on clean systems and even test VPSs, and I try to make this guide accurate, practical, and without additional margins so that you can quickly achieve results. In this tutorial, we will go step by step from installation to working with the MySQL command line.

Prerequisites

Before you start, make sure:

• You have access to the terminal
• You have sudo access
• The system is connected to the Internet
• The Kali Linux operating system is up to date (very important to avoid dependency errors)

Step 1: Update the Package List

Before installing any service on Linux, updating the repositories will help you avoid dealing with outdated versions or expired links.

sudo apt-get update

This command will refresh the list of packages in the repositories so that the latest version is downloaded during installation.

Step 2: Install MySQL Server

Now we’ll install MySQL itself:

sudo apt-get install mysql-server

During the installation, it may ask a few simple questions; usually, proceed with Yes or Enter.

If the system is freshly installed, this step will be completed without any problems.

Step 3: Run the MySQL Service

After installation, we start the database service:

sudo service mysql start

If you see no error returning to the command line, the service is running.

Stop the MySQL service (if needed)

If you want to stop the service:

sudo service mysql stop

This command is useful when you want to free up system resources or make certain adjustments.

Step 4: Log in to the MySQL Shell

To log in to the MySQL command line environment:

mysql -u root -p

After running, you will be asked for the database root password, Enter the password, nothing will be displayed, which is normal.

If you are logged in to the mysql> environment, the connection was successful.

Drop a database

DROP DATABASE mydatabase;

This command is not reversible, the entire database will be deleted.

Step 6: Basic commands you always use

Show all databases

SHOW DATABASES;

Select a database to work with

USE mydatabase;

From now on, commands will be executed on this database.

Create a table

CREATE TABLE mytable (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT
);

Show tables

SHOW TABLES;

Show table structure

DESCRIBE mytable;

Step 7: Insert data

INSERT INTO table1 (id, name) VALUES (1, 'John');

Very useful for initial testing.

Some practical experience that will help you further

Based on experience installing MySQL on Kali test systems:

• Most problems occur when the system is not updated
• If the service is not running, it is usually solved by a reboot
• On Kali, it is better to keep the database running only when you need it
• For practicing SQL, the MySQL Shell environment is much faster than graphical tools, you can always look for more tips on our website.

Conclusion

Installing and setting up MySQL on Kali Linux isn’t really complicated, if you follow the steps in order, the whole process can be completed in a matter of minutes. With your system updated, the packages properly installed, and the service running, you’ll have a practically complete database that you can use for practice, penetration testing, educational projects, and data storage. If you’re comfortable with the terminal, the MySQL Shell is one of the fastest and cleanest ways to manage a database. From there, you can move on to more advanced topics like query writing, indexing, and optimization.