install mysql on ubuntu: CLI Reference & Troubleshooting

install mysql on ubuntu is the APT-based deployment of MySQL 8.x server on Ubuntu 20.04/22.04, followed by mysql_secure_installation and root authentication plugin configuration.

# Update package index and install MySQL server
sudo apt update
sudo apt install mysql-server -y

install mysql on ubuntu Syntax Reference

The commands below represent a complete installation workflow. Copy and paste the block into your terminal on a fresh Ubuntu system.

# Update package index and install MySQL server
sudo apt update
sudo apt install mysql-server -y

# Check service status
sudo systemctl status mysql

# Secure the installation (interactive)
sudo mysql_secure_installation

# Log in as root (if auth_socket is default)
sudo mysql

# Check bind address (default 127.0.0.1)
sudo ss -tlnp | grep 3306

install mysql on ubuntu Rapid Reference Cheat Sheet

Advanced Implementation & Parameters

Choosing the exact MySQL version

# See available versions in native repos
apt-cache policy mysql-server-8.0

# For Ubuntu 22.04, the native package is 8.0.36-0ubuntu0.22.04.1
# To get 8.0.37, add the official MySQL APT repo:
wget https://dev.mysql.com/get/mysql-apt-config_0.8.30-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.30-1_all.deb
sudo apt update
sudo apt install mysql-server

Root authentication plugin behavior

On Ubuntu, the default mysql-server package configures root to use auth_socket. This means only the OS root user can authenticate without a password via sudo mysql. To enable password-based login for remote or application access, alter the plugin:

-- Connect via socket as OS root
sudo mysql

-- Switch to caching_sha2_password and set a password
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'YourStr0ngP@ss';
FLUSH PRIVILEGES;

Bind address and remote access

# Default: only loopback
sudo grep bind-address /etc/mysql/mysql.conf.d/mysqld.cnf

# To allow remote connections, change to 0.0.0.0 or a specific IP:
sudo sed -i 's/^bind-address.*/bind-address = 0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl restart mysql

# Verify listening on all interfaces
sudo ss -tlnp | grep mysql

Creating a dedicated application user

-- Inside mysql shell
CREATE USER 'app_user'@'192.168.0.%' IDENTIFIED BY 'AppP@ss2025';
GRANT SELECT, INSERT, UPDATE, DELETE ON mydb.* TO 'app_user'@'192.168.0.%';
FLUSH PRIVILEGES;

Error Resolution & Troubleshooting

Checking logs quickly

# General error log
sudo grep -i 'error' /var/log/mysql/error.log

# Service logs from systemd
sudo journalctl -u mysql --since "5 minutes ago"

# Test connectivity
mysql -u root -h 127.0.0.1 -P 3306 -p --protocol=tcp

Production-Grade Implementation

Security hardening after installation

# Run the interactive secure script
sudo mysql_secure_installation

# Remove anonymous users
# Disallow root login remotely
# Remove test database
# Reload privilege tables

Performance tuning (MySQL 8.0)

Modify /etc/mysql/mysql.conf.d/mysqld.cnf with realistic values. Example for a 4 vCPU, 16 GB RAM server:

[mysqld]
innodb_buffer_pool_size = 8G
innodb_log_file_size = 2G
max_connections = 200
table_open_cache = 4000
query_cache_type = 0    # deprecated in 8.0

Apply and restart: sudo systemctl restart mysql.

Automated deployment (Ansible snippet)

- name: Install MySQL on Ubuntu
  hosts: dbservers
  become: yes
  tasks:
    - name: Install mysql-server
      apt:
        name: mysql-server-8.0
        state: present
        update_cache: yes
    - name: Start and enable mysql
      systemd:
        name: mysql
        state: started
        enabled: yes
    - name: Run mysql_secure_installation non-interactively
      expect:
        command: mysql_secure_installation
        responses:
          'Enter current password for root': ''
          'Switch to unix_socket': 'y'
          'Change the root password?': 'y'
          'New password:': 'SecretP@ss123'
          'Re-enter new password:': 'SecretP@ss123'
          'Remove anonymous users?': 'y'
          'Disallow root login remotely?': 'y'
          'Remove test database?': 'y'
          'Reload privilege tables now?': 'y'

Backup strategy

# Full backup using mysqldump
mysqldump -u root --all-databases --routines --triggers --single-transaction > full_backup.sql

# Restore
mysql -u root < full_backup.sql

# Physical backup (using XtraBackup for large datasets)
xtrabackup --backup --target-dir=/backup/mysql

Tested on Ubuntu 22.04 LTS with mysql-server-8.0 (8.0.36) from native repos.

Frequently Asked Questions

apt show mysql-server 2>/dev/null | grep Version
apt show mysql-server-8.0 2>/dev/null | grep Version

mysqld --defaults-file=/etc/mysql/custom.cnf --user=mysql

sudo add-apt-repository universe
sudo apt update

wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.24-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.24-1_all.deb
sudo apt update && sudo apt install mysql-server

sudo apt update && sudo apt install -y software-properties-common
sudo add-apt-repository universe && sudo apt install mysql-server

sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password MySecurePass1!'
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password MySecurePass1!'
sudo DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server