MySQL DBA
- Buy now
- Learn more
- Discussions
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

Using MySQL Programs

6 Lessons