# How to Install MySQL on Linux Ubuntu


Installing MySQL on your Ubuntu Linux system is a straightforward process that anyone can master. Whether you're setting up a database for a personal project or a professional environment, MySQL remains one of the most popular and reliable database management systems. In this guide, I’ll walk you through the steps to install MySQL on Ubuntu, making sure you understand each part clearly.

You don’t need to be a Linux expert to follow along. I’ll explain everything in simple terms, so you can get your MySQL server up and running quickly. Let’s dive into the process and get your database ready for action.

## What is MySQL and Why Use It on Ubuntu?

MySQL is an open-source relational database management system. It helps you store, organize, and retrieve data efficiently. Many websites, applications, and services rely on MySQL because it is fast, reliable, and easy to use.

Ubuntu is one of the most popular Linux distributions, known for its user-friendliness and strong community support. Installing MySQL on Ubuntu is common for developers and system administrators who want a stable and secure database environment.

Here’s why MySQL on Ubuntu is a great choice:

- **Open-source and free:** No licensing fees.
- **Strong community support:** Lots of tutorials and forums.
- **Secure:** Regular updates and patches.
- **Scalable:** Works well for small projects and large applications.
- **Compatible:** Supports many programming languages and tools.

## Preparing Your Ubuntu System for MySQL Installation

Before installing MySQL, it’s important to prepare your Ubuntu system. This ensures the installation goes smoothly and your server is secure.

### Update Your Package Index

First, update your system’s package list. This makes sure you get the latest versions of software.

```bash
sudo apt update
```

### Upgrade Installed Packages

Upgrading existing packages helps avoid conflicts during installation.

```bash
sudo apt upgrade -y
```

### Install Required Dependencies

MySQL requires some basic tools and libraries. Usually, Ubuntu has these by default, but you can install them just in case.

```bash
sudo apt install wget curl gnupg -y
```

These commands prepare your system to download and install MySQL safely.

## Step-by-Step Guide to Install MySQL on Ubuntu

Now that your system is ready, let’s install MySQL. I’ll guide you through each step.

### 1. Install MySQL Server Package

Ubuntu’s default repositories include MySQL. You can install it with this command:

```bash
sudo apt install mysql-server -y
```

This downloads and installs the MySQL server and related tools.

### 2. Verify MySQL Service Status

After installation, check if MySQL is running:

```bash
sudo systemctl status mysql
```

You should see a message indicating the service is active and running. If not, start it manually:

```bash
sudo systemctl start mysql
```

### 3. Secure Your MySQL Installation

MySQL comes with a security script to improve your server’s safety. Run it with:

```bash
sudo mysql_secure_installation
```

This script will ask you to:

- Set a root password (if not set).
- Remove anonymous users.
- Disallow remote root login.
- Remove test databases.
- Reload privilege tables.

Answer the prompts carefully to secure your database.

### 4. Log into MySQL Shell

To manage your databases, log into the MySQL shell:

```bash
sudo mysql -u root -p
```

Enter your root password when prompted. You’ll see the MySQL prompt where you can run SQL commands.

## Basic MySQL Commands to Get Started

Once inside the MySQL shell, here are some basic commands to help you start:

- **Show databases:**

  ```sql
  SHOW DATABASES;
  ```

- **Create a new database:**

  ```sql
  CREATE DATABASE mydatabase;
  ```

- **Use a database:**

  ```sql
  USE mydatabase;
  ```

- **Create a new user and grant privileges:**

  ```sql
  CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
  GRANT ALL PRIVILEGES ON mydatabase.* TO 'newuser'@'localhost';
  FLUSH PRIVILEGES;
  ```

- **Exit MySQL shell:**

  ```sql
  EXIT;
  ```

These commands help you manage your data and users securely.

## Managing MySQL Service on Ubuntu

Knowing how to control the MySQL service is important for maintenance and troubleshooting.

### Start MySQL Service

```bash
sudo systemctl start mysql
```

### Stop MySQL Service

```bash
sudo systemctl stop mysql
```

### Restart MySQL Service

```bash
sudo systemctl restart mysql
```

### Enable MySQL to Start on Boot

```bash
sudo systemctl enable mysql
```

### Disable MySQL from Starting on Boot

```bash
sudo systemctl disable mysql
```

These commands give you control over when MySQL runs on your system.

## Troubleshooting Common MySQL Installation Issues

Sometimes, you might face issues during or after installation. Here are some common problems and how to fix them.

### MySQL Service Fails to Start

- Check error logs:

  ```bash
  sudo journalctl -xeu mysql
  ```

- Verify no other service is using port 3306.

- Restart the service:

  ```bash
  sudo systemctl restart mysql
  ```

### Authentication Errors

- If you can’t log in as root, try resetting the root password.

- Use the following to reset root password safely:

  1. Stop MySQL:

     ```bash
     sudo systemctl stop mysql
     ```

  2. Start MySQL without permission checking:

     ```bash
     sudo mysqld_safe --skip-grant-tables &
     ```

  3. Log in without password:

     ```bash
     mysql -u root
     ```

  4. Change password:

     ```sql
     ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
     FLUSH PRIVILEGES;
     EXIT;
     ```

  5. Restart MySQL normally:

     ```bash
     sudo systemctl restart mysql
     ```

### Package Installation Errors

- Run:

  ```bash
  sudo apt --fix-broken install
  ```

- Clean package cache:

  ```bash
  sudo apt clean
  sudo apt update
  ```

These steps usually resolve installation problems.

## Updating MySQL on Ubuntu

Keeping MySQL updated is important for security and performance.

### Check for Updates

```bash
sudo apt update
sudo apt upgrade mysql-server -y
```

### Verify MySQL Version

```bash
mysql --version
```

Regular updates ensure you have the latest features and patches.

## Using MySQL Workbench with Ubuntu

If you prefer a graphical interface, MySQL Workbench is a great tool.

### Install MySQL Workbench

```bash
sudo apt install mysql-workbench -y
```

### Connect to Your MySQL Server

- Open MySQL Workbench.
- Create a new connection with your server details.
- Use your root or user credentials.
- Manage databases visually.

This makes database management easier, especially if you’re new to command-line tools.

## Conclusion

Installing MySQL on Ubuntu is a simple process that anyone can follow. By updating your system, installing the MySQL server, securing it, and learning basic commands, you’ll have a powerful database ready for your projects. Managing the MySQL service and troubleshooting common issues will keep your server running smoothly.

Whether you prefer command-line or graphical tools like MySQL Workbench, Ubuntu offers a flexible environment for MySQL. With regular updates and security practices, your database will stay reliable and safe. Now you’re ready to build and manage your data with confidence.

---

### FAQs

### How do I check if MySQL is installed on Ubuntu?

You can check by running `mysql --version` in the terminal. If MySQL is installed, it will display the version number.

### What is the default MySQL root password on Ubuntu?

By default, the root user has no password after installation. You should set one using `mysql_secure_installation`.

### Can I install a specific version of MySQL on Ubuntu?

Yes, you can add the official MySQL APT repository to install specific versions.

### How do I allow remote connections to MySQL on Ubuntu?

Edit the MySQL configuration file to bind to `0.0.0.0` and grant privileges to remote users.

### How do I uninstall MySQL from Ubuntu?

Use `sudo apt remove --purge mysql-server mysql-client mysql-common -y` and then clean residual files.