How To Install MySQL Server & MySQL Workbench on Ubuntu Linux (2025)

How to Install MySQL Server and MySQL Workbench on Ubuntu 24.04 LTS Linux
Learn how to install *MySQL Server* and *MySQL Workbench* on Ubuntu 24.04 LTS Linux in this comprehensive tutorial. This step-by-step guide will walk you through installing the MySQL database server and its graphical user interface (GUI) client for managing your databases efficiently.

---

What is MySQL?
*MySQL* is a widely used open-source relational database management system. It’s ideal for web applications, data analysis, and enterprise solutions. MySQL Workbench complements it with a GUI for database modeling, SQL development, and server administration.

---

Steps to Install MySQL Server

#### 1. *Update System Packages*
Start by updating your package lists:
```bash
sudo apt update && sudo apt upgrade -y
```

#### 2. *Install MySQL Server*
Install the MySQL Server package using the following command:
```bash
sudo apt install mysql-server -y
```

#### 3. *Secure MySQL Installation*
Run the MySQL security script to configure recommended security settings:
```bash
sudo mysql_secure_installation
```
Follow the prompts to set up a root password, remove anonymous users, disallow root login remotely, and remove test databases.

#### 4. *Verify MySQL Installation*
Check if MySQL is running:
```bash
sudo systemctl status mysql
```
Login to MySQL to confirm:
```bash
sudo mysql -u root -p
```

---

Steps to Install MySQL Workbench

#### 1. *Add MySQL APT Repository*
Download and add the MySQL APT repository to ensure you get the latest version of Workbench:
```bash
wget
sudo dpkg -i mysql-apt-config_0.8.25-1_all.deb
sudo apt update
```

#### 2. *Install MySQL Workbench*
Install MySQL Workbench with the following command:
```bash
sudo apt install mysql-workbench -y
```

#### 3. *Launch MySQL Workbench*
You can start MySQL Workbench from the applications menu or by running:
```bash
mysql-workbench
```

---

Testing Your Installation

#### 1. *Connect to MySQL Server*
Open MySQL Workbench.
Click on *+* to create a new connection.
Enter your credentials (e.g., root user and password).
Test the connection and save.

#### 2. *Run SQL Queries*
Use the SQL editor to run queries and manage your databases.

---

Additional Tips
Regularly update MySQL and Workbench for new features and security patches:
```bash
sudo apt update && sudo apt upgrade
```
Use MySQL Workbench for database design, query optimization, and server management.
Monitor your database performance and set up proper backup solutions.

With MySQL Server and Workbench installed on Ubuntu 24.04 LTS, you're all set to build and manage robust databases. Like, share, and subscribe for more Linux tutorials!