Mysql Admin Course Content
Installing MySQL
- Installation Choices & Platforms
- Using the Command-Line Interface
- Downloading & Verifying Files from the MySQL AB Web Site
- Installing Under Linux
- Installing Under Windows
- Configuring Access to the MySQL Server
Using the MySQL Monitor
- Starting the Monitor
- Style, Case & Semicolons
- The Monitor Help
- Running the Monitor in Batch Mode
- Loading the Sample Databases
- MySQL Monitor Program Options
- Graphical Clients
Doing More with MySQL
- Loading Data from Comma-Delimited Files
- Writing Data into Comma-Delimited Files
- The EXPLAIN Statement
Managing Users & Privileges
- Understanding Users & Privileges
- Creating & Using New Users
- Privileges
- The GRANT OPTION Privilege
- How Privileges Interact
- Users and Hosts
- Checking Privileges
- Revoking Privileges
- Removing Users
- Understanding & Changing Passwords
- The Default Users
- Devising a User Security Policy
- Managing Privileges with SQL
- Privileges & Performance
- Resetting Forgotten MySQL Passwords
Backups & Recovery
- Dumping a Database as SQL Statements
- Loading Data from an SQL Dump File
- Scheduling Backups
- The Binary Log
- Checking & Repairing Corrupted Tables
- Re-Creating Damaged Grant Tables
Using an Options File
- Configuring Options for the MySQL Monitor
- Structure of the Options File
- Scope of Options
- Search Order for Options Files
- Determining the Options in Effect
Configuring & Tuning the Server
- The MySQL Server Daemon
- Server Variables
- Checking Server Settings