If you're planning to set up a reliable database server on a Linux environment, MySQL is likely at the top of your list. Known for its speed, reliability, and open-source nature, MySQL is one of the most widely used relational database management systems in the world. In this guide, we’ll walk you through how to Install MySQL on Ubuntu 22.04, based on the official guide available at Vultr Docs. Whether you're a beginner or an experienced developer, this tutorial will help you install and configure MySQL for optimal performance.
Why Choose MySQL with Ubuntu 22.04?
MySQL is the database backbone of countless websites and applications, from content management systems like WordPress to large-scale enterprise software. Pairing it with Ubuntu 22.04, a Long-Term Support (LTS) version of Ubuntu Linux, gives you:
- Stability and Security: Ubuntu 22.04 receives regular security updates and patches until 2027.
- Community Support: Both MySQL and Ubuntu have large, active user communities.
- Open-Source Compatibility: Perfect for budget-conscious developers and startups.
By following a reliable installation guide such as the one provided by Vultr, you can ensure your server is set up securely and efficiently.
How to Install MySQL on Ubuntu 22.04
Below are the detailed steps to Install MySQL on Ubuntu 22.04. These steps are based on the Vultr documentation and tested for accuracy.
Step 1: Update Your Package Index
Always begin with updating your local package list to make sure you're installing the latest version available:
sudo apt update && sudo apt upgrade -y
This ensures system compatibility and reduces the chances of installation errors.
Step 2: Install MySQL Server
Ubuntu’s official repository includes MySQL, so installation is simple:
sudo apt install mysql-server -y
This command installs both the MySQL server and its dependencies.
Step 3: Start and Enable MySQL
Once installed, the MySQL service should start automatically. You can check its status with:
sudo systemctl status mysql
To make sure MySQL starts on boot:
sudo systemctl enable mysql
Step 4: Secure MySQL Installation
MySQL includes a built-in security script that helps you enhance the initial setup:
sudo mysql_secure_installation
You’ll be prompted to:
- Set a root password
- Remove anonymous users
- Disallow remote root login
- Remove test databases
- Reload privilege tables
Answer "Y" to all prompts unless you have specific needs.
Step 5: Access MySQL Shell
After securing MySQL, log into the MySQL shell to start managing databases:
sudo mysql -u root -p
Enter the root password you just created when prompted.
Optional: Allow Remote Connections (Advanced)
If you're using MySQL in a multi-server environment, you may need to enable remote access:
- Edit the MySQL config file:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
- Change the bind address:
bind-address = 0.0.0.0
- Restart MySQL:
sudo systemctl restart mysql
Also, make sure to configure your firewall to allow MySQL’s default port, 3306.
Conclusion
Successfully completing the steps to Install MySQL on Ubuntu 22.04 ensures you’re ready to manage data securely and efficiently. MySQL is a robust, fast, and scalable database system that integrates seamlessly with Ubuntu’s modern architecture.
This guide, based on Vultr's official tutorial, simplifies the process for users at any level. Whether you're building a local development environment or setting up a live server, this MySQL installation process will serve as your strong foundation.
Now that MySQL is installed, you can start creating databases, configuring users, and developing powerful data-driven applications.
