Step-by-Step Guide to Installing MySQL on Ubuntu Linux

MySQL is a popular open-source relational database management system that is widely used in web development. In this blog post, we will walk you through the process of installing MySQL on Ubuntu, a popular Linux distribution.

Step 1: Update the Ubuntu package index

Before installing MySQL, it's always a good idea to update the package index to ensure that you have the latest version of the software available. To do this, open a terminal window and run the following command:

sudo apt update

This command will update the package index on your Ubuntu system.

Step 2: Install MySQL

Once the package index is updated, you can install MySQL by running the following command:

sudo apt install mysql-server

This command will install the MySQL server and client on your Ubuntu system.

Step 3: Secure MySQL

By default, the MySQL installation on Ubuntu is not secured. To secure your MySQL installation, run the following command:

sudo mysql_secure_installation

This command will prompt you to set a root password, remove anonymous users, disallow root login remotely, and remove the test database. Follow the prompts to secure your MySQL installation.

Step 4: Test MySQL

After securing your MySQL installation, you can test it by running the following command:

sudo systemctl status mysql

This command will show you the status of the MySQL service. If the service is running, you should see a message indicating that the service is active (running).

Step 5: Connect to MySQL

To connect to your MySQL installation, you can use the following command:

mysql -u root -p

This command will prompt you for your root password. Enter the password you set earlier to connect to your MySQL installation.

Congratulations, you have successfully installed MySQL on your Ubuntu system! You can now use MySQL for your web development projects.

References:

1. Ubuntu documentation: https://ubuntu.com/server/docs/databases-mysql
2. MySQL documentation: https://dev.mysql.com/doc/