お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
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
要求
Fundamental knowledge of any database and SQL language.
14 時間
お客様の声 (5)
トレーニングでは、業務に関連する例を使用できます。
Aisha - Iziko Museums
コース - MySQL Database Administration
機械翻訳
実際の例。
Kesh Mulloo - Vodacom
コース - MySQL Database Administration
機械翻訳
The exercises done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
コース - MySQL Database Administration
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
コース - MySQL Database Administration
I enjoyed the backup and restore and multiple instances.
