Preview unavailable

Introduction to MySQL Server

• Introduction to MySQL

MySQL Architecture

• MySQL Server Architecture

Installing MySQL Server

• MySQL Installation Guide

• Overview of MySQL Installation

• Lab Practice: Installing MySQL Server

Exploring MySQL Installation

• MySQL Programs, Files and Directories

Connecting to MySQL Server

• Connecting to MySQL Server and executing Commands

Managing the Startup and Shutdown of MySQL Server

• Managing the Startup and Shutdown of MySQL Server

MySQL System Databases

• Overview of MySQL System Databases

About MySQL Programs

• Overview of MySQL Programs

• Invoking MySQL Programs

• Specifying Options on the Command Line

• Specifying Options in Option Files

• Specifying Options using Environment Variables

Using MySQL Programs

• mysql-config-editor

• mysqladmin

• mysqlshow

• mysqlimport

• mysqlcheck

• mysql-tzinfo-to-sql

Server Configuration

• About Configuring MySQL Server

• Sever Command Options

• Sever System Variables

• Server Status Variables

Managing MySQL Accounts

• About Managing MySQL Accounts

• Installing MySQL Client on Windows

• Lab Practice: Managing MySQL Accounts

Managing Privileges

• About Privileges in MySQL

• Lab Practice: Managing Privileges

Managing Roles

• About Roles

• Lab Practice: Managing Roles

Managing Databases

• Overview of Managing Databases

• Lab Practice: Creating, Using and Dropping Databases

MySQL Storage Engines

• Overview of MySQL Storage Engines

• Lab Practice: MySQL Storage Engines

InnoDB Storage Engine

• Creating File-Per-Table Tablespaces

• Managing File-Per-Table Tablespaces

• Overview of General Tablespaces

• Lab Practice: Creating and Managing General Tablespaces

• Overview of System Tablespace

• Lab Practice: Managing System Tablespace

• Overview of Undo Tablespaces

• Lab Practice: Managing Undo Tablespaces

• Overview of Temporary Tablespaces

• Lab Practices: Managing Temporary Tablespaces