Installing MySQL on Ubuntu 22.04

MySQL is a popular open-source relational database management system used for storing and managing data. It is widely used in web applications and provides a reliable, scalable, and secure solution for database management.

Step 1: Update system packages

Before installing MySQL, it's recommended to update the system packages to the latest versions. Open a terminal and run the following commands:

    
      sudo apt update
      sudo apt upgrade
    
  

Step 2: Install MySQL

To install MySQL, run the following command:

    
      sudo apt install mysql-server
    
  

During the installation process, you will be prompted to set a root password for the MySQL server. Choose a strong password and remember it as you will need it to access the database later.

Step 3: Secure MySQL installation

Once the installation is complete, you can secure your MySQL installation by running the MySQL secure installation script:

    
      sudo mysql_secure_installation
    
  

Follow the prompts and answer the questions accordingly to secure your MySQL installation.

Step 4: Verify MySQL installation

To verify that MySQL is running correctly, you can use the following command:

    
      sudo systemctl status mysql
    
  

If MySQL is running, you should see an "active (running)" status in the output.

Step 5: Access MySQL

To access the MySQL command-line interface, use the following command:

    
      mysql -u root -p
    
  

Enter the root password you set during the installation process to log in to the MySQL server.

Conclusion

You have successfully installed MySQL on Ubuntu 22.04. MySQL is now ready to use for your applications, and you can start creating and managing databases.