MySQL

MySQL arrow-up-rightis an open-source relational database management system (RDBMS) widely used for storing, managing, and retrieving structured data in applications ranging from web development to enterprise solutions.

Developed by Oracle Corporation, it supports SQL (Structured Query Language) for querying and manipulating data.

To get started with MySQL, there are 2 ways:

  • Linux (simpler)

  • Windows (simple, but more installations)


MySQL on Linux:

Install:

#Updating our distro
sudo apt update && sudo apt full-upgrade -y

#installing mysql-server
sudo apt install mysql-server

#If you are planning to launch a website with MySQL, I recommend installing this:
sudo apt install python3-dev default-libmysqlclient-dev build-essential pkg-config

#starting MySQL DB service 
sudo systemctl start mysql 

#starting MySQL to run on boot of the system
sudo systemctl enable mysql 

Now we have a database running on our system, we can verify this by checking our Ports or by just simply typing mysql


MySQL on Windows

Installing MySQL on Windows is simple and straightforward, it requires 2 installers:

triangle-exclamation

Install both of these applications (Install Workbench first)

Last updated