training@globalonlinetrainings.com

Mysql Admin

Mysql Admin Course Content

MySQL Introduction
Installing MySQL
  • Installation Choices & Platforms
  • Using the Command-Line Interface
  • Downloading & Verifying Files from the MySQL AB Web Site
  • Installing Under Linux
  • Installing Under Windows
  • Configuring Access to the MySQL Server
Using the MySQL Monitor
  • Starting the Monitor
  • Style, Case & Semicolons
  • The Monitor Help
  • Running the Monitor in Batch Mode
  • Loading the Sample Databases
  • MySQL Monitor Program Options
  • Graphical Clients
Doing More with MySQL
  • Loading Data from Comma-Delimited Files
  • Writing Data into Comma-Delimited Files
  • The EXPLAIN Statement
Managing Users & Privileges
  • Understanding Users & Privileges
  • Creating & Using New Users
  • Privileges
  • The GRANT OPTION Privilege
  • How Privileges Interact
  • Users and Hosts
  • Checking Privileges
  • Revoking Privileges
  • Removing Users
  • Understanding & Changing Passwords
  • The Default Users
  • Devising a User Security Policy
  • Managing Privileges with SQL
  • Privileges & Performance
  • Resetting Forgotten MySQL Passwords
Backups & Recovery
  • Dumping a Database as SQL Statements
  • Loading Data from an SQL Dump File
  • Scheduling Backups
  • The Binary Log
  • Checking & Repairing Corrupted Tables
  • Re-Creating Damaged Grant Tables
Using an Options File
  • Configuring Options for the MySQL Monitor
  • Structure of the Options File
  • Scope of Options
  • Search Order for Options Files
  • Determining the Options in Effect
Configuring & Tuning the Server
  • The MySQL Server Daemon
  • Server Variables
  • Checking Server Settings