         MySQL Database Administration培訓

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