MySQL Database Administration Training Course

MySQL Server Files and Scripts

• MySQL Applications
• MySQL Server
• MySQL Client
• Graphical User Interface (GUI) Tools

Configuring the MySQL Server

• mysqld Command-Line Options
• Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Server Shutdown Procedure

Addressing MySQL Security Concerns

• Protecting MySQL from Security Threats
• Security-Specific mysqld Options
• Vulnerabilities Associated with LOAD DATA LOCAL

The MySQL Access Privilege System

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

Managing MySQL User Accounts

• User Identification and Passwords
• Provisioning New Users
• Removing User Accounts
• Restricting User Resources
• Modifying Passwords

MySQL Database Upkeep

• Backup and Restoration Procedures
• Point-in-Time Recovery Techniques
• Maintenance Tasks and Crash Restoration
• myisamchk Syntax and Parameters
• Retrieving Table Metadata
• MySQL Local Configuration
• Character Sets and Sorting Rules
• MySQL Server Time Zone Settings

MySQL Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Log File Management and Rotation

Operating Multiple MySQL Servers on a Single Machine

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