Master MySQL with Excellent Free Books

MySQL Notes for Professionals

(199 pages)

This MySQL Notes for Professionals book is compiled from Stack Overflow Documentation.

Chapters cover:

• 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
• MylSAM Engine
• Converting from MylSAM to InnoDB
• Transaction
• Log files
• Clustering
• Partitioning
• Replication
• Backup using mysqldump
• mysqlimport
• LOAD DATA INFILE
• MySDL Unions
• MySQL client
• Temporary Tables
• Customize PS1
• Dealing with sparse or missing data
• Connecting with UTF-8 using various programming languages
• 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

The text is released under the Creative Commons BY-SA license.

MySQL

By Wikibooks (82 pages)

Chapters cover:

• Introduction
• MySQL Practical Guide
• Databases manipulation
• Language
• Language/Browsing the databases
• Language/Specifying names
• Language/Definitions: what are DDL, DML and DQL?

Permission is granted to copy, distribute, and/or modify this document under the terms of the Creative Commons Attribution-ShareAlike 3.0 License.

Intrusion Detection with SNORT: Using SNORT, Apache, MySQL, PHP, and ACID

By Rafeeq Ur Rehman (275 pages)

Snort is an open source Network Intrusion Detection System (NIDS) which is available free of cost.

Chapters cover:

• What is Intrusion Detection?
• Installing Snort and Getting Started
• Working with Snort Rules
• Plugins, Preprocessors and Output Modules
• Using Snort with MySQL
• Using ACID and SnortSnarf with Snort
• Miscellaneous Tools

This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later.

MySQL 8.0 Reference Manual

By MySQL Documentation Team (5480 pages)

This is the MySQL Reference Manual. It documents MySQL 8.0 through 8.0.15. It is official documentation.

You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You cannot publish or distribute this documentation in any form or on any media