If you want to Install MySQL Ubuntu systems for web applications, development environments, or database hosting, Ubuntu 26.04 offers a fast and reliable setup process. MySQL remains one of the most trusted open-source relational database systems used in modern Linux infrastructures.
This guide explains how to install MySQL 8.4 on Ubuntu 26.04, secure the server, create databases, and enable remote access safely.
MySQL is widely used in LAMP and LEMP stacks because it delivers excellent performance, scalability, and stability. Developers often pair it with PHP, Apache, or Nginx for hosting websites and enterprise applications.
Ubuntu 26.04 ships with MySQL 8.4 directly from its official repositories, making installation simple and secure.
Before starting, ensure your account has sudo privileges.
First, refresh the package index:
sudo apt update
Next, install the MySQL server package:
sudo apt install mysql-server
Once installation finishes, the MySQL service starts automatically. Verify the service status with:
sudo systemctl status mysql
You should see the service marked as active and running.
To confirm the installed version, run:
mysql --version
This command displays the MySQL release currently installed on your Ubuntu system.
After installation, securing the database server is extremely important. MySQL includes a built-in security script that helps remove unsafe defaults.
Run the following command:
sudo mysql_secure_installation
During the setup process, you can:
For production servers, selecting at least the MEDIUM password policy is recommended.
After securing the server, you can create databases and dedicated user accounts.
Open the MySQL shell:
sudo mysql
Create a new database:
CREATE DATABASE myapp;
Now create a new user and assign permissions:
CREATE USER 'myappuser'@'localhost' IDENTIFIED BY 'strong_password';GRANT ALL PRIVILEGES ON myapp.* TO 'myappuser'@'localhost';FLUSH PRIVILEGES;
Using separate accounts instead of the root user improves overall security.
By default, MySQL only accepts local connections. If remote access is required, edit the MySQL configuration file:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Locate the bind-address setting and update it:
bind-address = 0.0.0.0
Restart MySQL afterward:
sudo systemctl restart mysql
You should also allow port 3306 through the firewall for trusted IP addresses only:
sudo ufw allow from 192.168.1.100 to any port 3306
Avoid exposing MySQL publicly unless absolutely necessary.
Learning how to Install MySQL Ubuntu servers correctly is essential for building secure and scalable Linux hosting environments. Ubuntu 26.04 simplifies the deployment process while MySQL 8.4 provides modern authentication, strong performance, and enterprise-ready features.
After completing the setup, you can continue by integrating MySQL with PHP, WordPress, Laravel, or containerized applications for production workloads.
Introduction Bash scripting is a powerful way to automate Linux tasks, but writing a script…
Introduction A self-signed SSL certificate is a certificate that is created and signed by the…
Introduction Debugging is an important part of Bash scripting. When a script does not work…
Introduction Cron jobs are used in Linux to run commands or Bash scripts automatically at…
Introduction Pipes are an important feature in Linux and Bash scripting. A pipe allows you…
Introduction The grep, awk, and sed commands are powerful text-processing tools in Linux. They are…