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:
- Ubuntu documentation: https://ubuntu.com/server/docs/databases-mysql
- MySQL documentation: https://dev.mysql.com/doc/
