Παίζοντας με μερικές απλές εντολές με την mysql βάση δεδομένων που βρίσκεται πάνω στον vulnerable metasploitable server μας. Τίποτα το προχωρημένο άλλα απλές και βασικές εντολές με διάφορες εναλλακτικές που κάποιος μπορεί να χρισιμοποιήσει. Channel Link: https://peertube.it/c/m3tahckr/videos Tuttorial Link: https://peertube.it/w/2qdbAKn3vFp6AbW1tU4YSd

Chapters Getting started with MySQL Data Types SELECT Backticks NULL Limit and Offset Creating databases Using Variables Comment MySQL INSERT DELETE UPDATE ORDER BY Group By Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ... Joins JOINS: Join 3 table with the same name of id. UNION Arithmetic String operations Date and Time Operations Handling Time Zones Regular Expressions VIEW Table Creation ALTER TABLE Drop Table MySQL LOCK TABLE Error codes Stored routines (procedures and functions) Indexes and Keys Full-Text search PREPARE Statements JSON Extract values from JSON type MySQL Admin TRIGGERS Configuration and tuning Events ENUM Install Mysql container with Docker-Compose Character Sets and Collations MyISAM Engine Converting from MyISAM to InnoDB Transaction Log files Clustering Partitioning Replication Backup using mysqldump mysqlimport LOAD DATA INFILE MySQL Unions MySQL client Temporary Tables Customize PS1 Dealing with sparse or missing data Connecting with UTF-8 Using Various Programming language. Time with subsecond precision One to Many Server Information SSL Connection Setup Create New User Security via GRANTs Change Password Recover and reset the default root password for MySQL 5.7+ Recover from lost root password MySQL Performance Tips Performance Tuning Reserved Words MySQLNotesForProfessionals.pdf