🚀 Installing MySQL Server and Workbench on Ubuntu 24.04

In this guide, we’ll install MySQL Server 8.0 and MySQL Workbench on Ubuntu 24.04. This setup is useful if you’re developing apps locally or managing databases directly on your server.

🔹 Step 1: Update and Upgrade Packages

Always refresh your system before installing:

sudo apt update
sudo apt upgrade -y

🔹 Step 2: Install MySQL Server

sudo apt install mysql-server -y

Check the installation:

sudo mysql -v

🔹 Step 3: Secure the Installation

Run the security script:

sudo mysql_secure_installation

When prompted, typical answers are:

Validate Password Component?  Y
Password Policy: 0 (LOW)
Remove anonymous users?      Y
Disallow root login remotely? Y
Remove test database?        Y
Reload privilege tables now? Y

🔹 Step 4: Set Root Password

Login to MySQL:

sudo mysql

Change the root password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';

Exit MySQL, then log in with your new password:

mysql -u root -p

🔹 Step 5: Verify Ubuntu Version

lsb_release -d

🔹 Step 6: Install MySQL Workbench

Download the .deb package from the official site: 👉 MySQL Workbench Downloads

Or via wget:

wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.43-1ubuntu24.04_amd64.deb

Check your directory:

ls

Install the package:

sudo dpkg -i mysql-workbench-community_8.0.43-1ubuntu24.04_amd64.deb

If you get dependency errors, fix them:

sudo apt --fix-broken install

Sometimes you may also need extra libraries:

sudo apt install libproj-dev proj-bin -y

🔹 Step 7: Verify Installation

Check MySQL Server version:

mysql --version

Check MySQL Workbench version:

mysql-workbench --version

✅ Conclusion

You now have both MySQL Server 8.0 and MySQL Workbench installed on Ubuntu 24.04. Use the mysql CLI for server-side management, and Workbench (GUI) on your desktop for a friendlier interface.