MySQL is one of the most popular open-source relational database management systems, widely used for building and managing databases in various applications. MySQL is a powerful database management system that can handle various data-driven applications. If you're an Ubuntu 22 user and want to install MySQL, this article will provide you with a detailed step-by-step guide to help you through the process.
Step 1: Update System Packages.
Before installing any software, it's essential to update the system packages to ensure you have the latest versions. Open a ssh terminal and run the following commands:
sudo apt update -y
sudo apt upgrade -y
Step 2: Install MySQL Server
To install MySQL on Ubuntu 22, use the following command:
sudo apt install mysql-server -y
During the installation, you will be prompted to set a root password. Enter a strong password and keep it safe. Once the installation is complete, MySQL will start automatically.
Step 3: Configure MySQL Security.
For security purposes, it's recommended to run the MySQL secure installation script. This script allows you to set several security-related options. Run the following command in the terminal:
You'll be prompted to enter the root password you set during installation. Follow the prompts and answer the questions based on your security preferences.
Step 4: Verify MySQL Installation.
To check if MySQL is running correctly, you can use the following command to start the MySQL command-line interface:
If you successfully enter the MySQL shell, the installation was successful.
Exit the MySQL shell typing:
Step 5: Basic MySQL Configuration.
By default, MySQL listens only on the localhost (127.0.0.1) IP address. If you want to allow connections from remote machines, you need to edit the MySQL configuration file.
Open the file using a text editor with root privileges:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Locate the line
bind-address = 127.0.0.1 and replace it with
bind-address = 0.0.0.0 to allow connections from any IP address.
Save the changes and exit the text editor.
Step 6: Restart MySQL Service.
To apply the changes made in the configuration file, restart the MySQL service with the following command:
sudo systemctl mysql restart
If you want the MySQL Server to start autoamtically each time the Ubuntu Machine reboots then do:
sudo systemcl mysql enable
Step 7: Test Remote Connection (Optional)
If you modified the MySQL configuration to allow remote connections, you can test it from another machine.
Use a MySQL client software such as MySQL Workbench or the command-line tool to connect to the MySQL server using the IP address of your Ubuntu machine.
- Using MySql Workbench to model and create a Database Schema with Tables
- Connect MySql Workbench to a DB running in a Vagrant Machine