MySQL Database Administration Training Course

MySQL Server Files and Scripts

• MySQL Programs
• MySQL Server
• MySQL Client
• GUI Tools

Configuring the MySQL Server

• mysqld Options
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Process

Addressing MySQL Security Concerns

• Protecting MySQL from Attacks
• Security-Focused mysqld Options
• Security Considerations for LOAD DATA LOCAL

The MySQL Access Privilege System

• Overview of the MySQL Privilege System
• Privileges Granted by MySQL
• Connecting to the MySQL Server - Phases
• Access Control, Phase 1: Verifying Connections
• Access Control, Phase 2: Validating Requests
• Handling Access Denied Errors

Managing MySQL User Accounts

• Users and Passwords
• Creating New Users
• Removing User Accounts
• Restricting User Resources
• Updating Passwords

Maintaining MySQL Databases

• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Retrieving Table Information
• MySQL Local Settings
• Character Sets and Sorting
• MySQL Server Time Zones

MySQL Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Maintaining and Rotating Log Files

Operating Multiple MySQL Servers on a Single Machine

• Running Multiple Servers on Windows
• Managing Multiple Servers on Windows as Services
• Running Multiple Servers on Unix and Linux
• Using Client Tools in a Multi-Server Setup