MySQL Setup and Configuration

What is MySQL?

MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the abbreviation for Structured Query Language.

MySQL Setup

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

sudo mysql

CREATE USER 'habib'@'localhost' IDENTIFIED BY 'password';

grant all privileges on *.* to 'habib'@'localhost';

FLUSH PRIVILEGES;

mysql -u root -p

CREATE DATABASE testDB;