MySQL Database Administration Training Course

MySQL Server Files and Scripts

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

MySQL Server Configuration

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

MySQL Security Issues

• Securing MySQL Against Attacks
• Security-Related mysqld Options
• Security Issues with LOAD DATA LOCAL

MySQL Access Privilege System

• MySQL Privilege System Overview
• Privileges Provided by MySQL
• Connecting to the MySQL Server - Stages
• Access Control, Stage 1: Connection Verification
• Access Control, Stage 2: Request Verification
• Access Denied Errors

MySQL User Account Management

• Users and Passwords
• Creating New Users
• Deleting User Accounts
• Limiting User Resources
• Changing Passwords

MySQL Database Maintenance

• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Getting Table Information
• MySQL Local Setting
• National Characters and Sorting
• MySQL Server Time Zone

MySQL Log Files

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

Running Multiple MySQL Servers on the Same Machine

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