Serverspace Black Friday
JT
October 12 2023
Updated October 12 2023

How To Install Mysql on Ubuntu?

Databases Ubuntu

Introduction

MySQL is a highly favored choice in modern network and automation systems for its robust features and capabilities. As a reliable and scalable Relational Database Management System (RDBMS), it ensures data integrity, critical in these contexts where structured data, such as configurations and device states, must be efficiently managed.

Its excellent performance, open-source nature, and extensive community support make it accessible and adaptable to various environments. MySQL's security features safeguard sensitive information, and its compatibility with different programming languages and tools enhances integration. Moreover, it offers reliability and availability solutions, minimizing downtime. In essence, MySQL serves as the cornerstone for storing, retrieving, and analyzing critical data in contemporary network and automation systems.

How to download it?

At the official site we can see different way to download various type of product, for bunch operating systems and packet managers:

List of software
Screenshot №1 — List of software

In our guide we will consider installation of two main components: Community Server and Cluster on Ubuntu. First product represent open-source and free database which fit to various cases: store data for applications, web-sites, small automation system or minimum usage data.

Second product represent by self enhanced version of Community product with key points difference scalability and fault-tolerance for using in complex automation system. That can be possible due to replication mechanism which copy data to several host at the same moment.

Download interface
Screenshot №2 — Download interface

For installing package we can use graphic or CLI shell, due to reason of server usually don't have graphic interface, we will consider CLI.

Highlight! If you use another OS you need to change category and work with them ahead.

Next step, download configuration file through wget utility, if don't have they, just type:

apt install wget -y

And now indicate link in the option for download:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.26-1_all.deb
Download package
Screenshot №3 — Download package

By that command we can install apt repository for the Ubuntu OS. Run it by the command below:

dpkg -i mysql-apt-config_0.8.26-1_all.deb
Select version
Screenshot №4 — Select version

We will install server, therefore choose first point in the menu above. Next we need to indicate version of using software, in our case it is mysql-8.0:

Choose version
Screenshot №5 — Choose version

If you choose version and script roll again, you can find button OK at the bottom of menu and exit from that. Next step, we will install package with server:

apt update && apt install mysql-server -y
Installation server
Screenshot №6 — Installation server

In the process of installation we can see pop-up menu, enter strong password with capital letters, special signs, don't use frequently word and length should be 13 signs at minimum. Maybe you have question, why we use exactly thirteen signs for that. Average time for brute-forcing data with that type is approximately several decades.

password
Screenshot №7 — Password

Follow step, you need to choose standart of encryption:

Encryption
Screenshot №8 — Encryption

After several screen with option we can enter to the MySQL system, by the command:

mysql -u root -p
Enter in the MySQL
Screenshot №9 — Enter in the MySQL

We indicate option with user, password and after entering the second, can use DBMS!

Conclusion

MySQL's versatility, performance, and security features make it a preferred choice for handling critical data in modern network and automation systems, and its installation process, as outlined in the guide, ensures a smooth setup on an Ubuntu-based system.

Vote:
5 out of 5
Аverage rating : 5
Rated by: 1
33145 North Miami, FL 2520 Coral Way apt 2-135
+1 302 425-97-76
700 300
ITGLOBAL.COM CORP
700 300

You might also like...

We use cookies to make your experience on the Serverspace better. By continuing to browse our website, you agree to our
Use of Cookies and Privacy Policy.