1. sudo apt update
2. sudo apt install mysql-server sudo systemctl start mysql.service sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; exit mysql -u root -p

===============

udo apt install docker.io sudo docker run --name mysql -d -p 3307:3306 -e MYSQL_ROOT_PASSWORD=root --restart unless-stopped mysql:8 sudo docker exec -it mysql mysql -p

==============

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS instructor_detail;

CREATE TABLE instructor_detail ( id int(11) NOT NULL AUTO_INCREMENT, youtube_channel varchar(128) DEFAULT NULL, hobby varchar(45) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS instructor;

CREATE TABLE instructor ( id int(11) NOT NULL AUTO_INCREMENT, first_name varchar(45) DEFAULT NULL, last_name varchar(45) DEFAULT NULL, email varchar(45) DEFAULT NULL, instructor_detail_id int(11) DEFAULT NULL, PRIMARY KEY (id), KEY FK_DETAIL_idx (instructor_detail_id), CONSTRAINT FK_DETAIL FOREIGN KEY (instructor_detail_id) REFERENCES instructor_detail (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

SET FOREIGN_KEY_CHECKS = 1;

=================

=================