How To Install MySQL On Ubuntu VPS Server

MySQL is one of the most widely used relational database management systems for:

• websites
• SaaS applications
• WordPress hosting
• APIs
• CRM systems
• enterprise applications

It is reliable,
scalable,
fast,
and highly optimized for Linux server environments.

In this guide,
you will learn how to install MySQL on an Ubuntu VPS server step-by-step.

Why Use MySQL?

MySQL is popular because it offers:

• high performance
• scalability
• reliability
• strong security
• wide application compatibility
• easy management

It is commonly used with:

• PHP
• WordPress
• Laravel
• Node.js
• Python applications
• business applications

Prerequisites

Before starting,
ensure you have:

• Ubuntu VPS server
• root or sudo access
• SSH access enabled
• stable internet connection

Recommended operating system:

Ubuntu 22.04 LTS

Step 1 — Connect To Your VPS Server

Connect to your Ubuntu VPS using SSH.

Command:

ssh root@your-server-ip

Example:

ssh root@192.168.1.10

Step 2 — Update Server Packages

Update existing packages before installation.

Command:

apt update && apt upgrade -y

This improves:

• security
• compatibility
• server stability

Step 3 — Install MySQL Server

Install MySQL using Ubuntu package manager.

Command:

apt install mysql-server -y

MySQL server packages will automatically install.

Step 4 — Start MySQL Service

Start MySQL service.

Command:

systemctl start mysql

Enable automatic startup on boot.

Command:

systemctl enable mysql

Step 5 — Verify MySQL Status

Check if MySQL is running correctly.

Command:

systemctl status mysql

If successful,
you should see:

active (running)

Step 6 — Secure MySQL Installation

Run MySQL security script.

Command:

mysql_secure_installation

This helps:

• remove anonymous users
• disable remote root login
• remove test databases
• improve database security

Step 7 — Login To MySQL

Access MySQL terminal.

Command:

mysql -u root -p

Enter your MySQL root password.

Step 8 — Create A New Database

Create a database.

Command:

CREATE DATABASE mydatabase;

Step 9 — Create MySQL User

Create a database user.

Command:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'StrongPassword';

Step 10 — Grant Database Permissions

Grant privileges to the user.

Command:

GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';

Reload privileges:

FLUSH PRIVILEGES;

Step 11 — Exit MySQL Terminal

Exit MySQL shell.

Command:

EXIT;

Important MySQL Commands

Start MySQL

systemctl start mysql

Stop MySQL

systemctl stop mysql

Restart MySQL

systemctl restart mysql

Check MySQL Status

systemctl status mysql

MySQL Configuration File

Main configuration file:

/etc/mysql/mysql.conf.d/mysqld.cnf

How To Enable Remote MySQL Access

Edit configuration file:

/etc/mysql/mysql.conf.d/mysqld.cnf

Find:

bind-address = 127.0.0.1

Change to:

bind-address = 0.0.0.0

Restart MySQL:

systemctl restart mysql

Configure Firewall For MySQL

Allow MySQL port:

ufw allow 3306

Reload firewall:

ufw reload

Common MySQL Errors

Access Denied Error

Possible causes:

• incorrect password
• insufficient permissions
• wrong user privileges

MySQL Service Not Starting

Check logs:

journalctl -xe

Port 3306 Already In Use

Check active processes:

netstat -tulpn | grep 3306

Why Businesses Use MySQL

Businesses choose MySQL because it provides:

• reliable database performance
• scalability
• application compatibility
• enterprise stability
• strong ecosystem support

It powers millions of:

• websites
• SaaS platforms
• business systems
• enterprise applications

Why Choose DJ Technologies VPS Hosting

DJ Technologies Linux VPS hosting includes:

• NVMe SSD infrastructure
• enterprise virtualization
• premium low latency network
• scalable cloud resources
• advanced security
• optimized VPS environments
• 24×7 technical support

Our VPS infrastructure is optimized for:

• MySQL hosting
• databases
• SaaS applications
• business platforms
• enterprise workloads

Final Thoughts

MySQL is one of the best database systems for Linux VPS hosting environments.

Its:

• performance
• scalability
• reliability
• compatibility

make it ideal for:

• websites
• business applications
• SaaS platforms
• APIs
• enterprise infrastructure.