MySQL Database Administration Training Course

MySQL Server Files and Scripts

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

Configuring the MySQL Server

• mysqld Options
• Server SQL Mode
• System Variables for the Server
• Dynamic System Variables
• Server Status Variables
• Shutdown Procedures

Addressing MySQL Security Concerns

• Protecting MySQL from Attacks
• Security-Focused mysqld Options
• Security Risks Associated with LOAD DATA LOCAL

The MySQL Access Privilege Framework

• Overview of the MySQL Privilege System
• Privileges Granted by MySQL
• Connecting to the MySQL Server - Steps Involved
• Access Control, Step 1: Verifying the Connection
• Access Control, Step 2: Verifying the Request
• Handling Access Denied Errors

Managing MySQL User Accounts

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

Maintaining MySQL Databases

• Backup and Recovery Strategies
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Retrieving Table Information
• Local MySQL Settings
• National Characters and Sorting
• Time Zone Configuration for the MySQL Server

Managing MySQL Log Files

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

Hosting Multiple MySQL Servers on a Single Machine

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