MySQL 5.0 Reference Manual :: 5 Database Administration
Section Navigation [Toggle]
- Preface
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 5.1 Overview of Server-Side Programs
- 5.2 mysqld — The MySQL Server
- 5.3 MySQL Server Startup Programs
- 5.4 mysqlmanager — The MySQL Instance Manager
- 5.5 Installation-Related Programs
- 5.6 General Security Issues
- 5.7 The MySQL Access Privilege System
- 5.8 MySQL User Account Management
- 5.9 Backup and Recovery
- 5.10 MySQL Localization and International Usage
- 5.11 MySQL Server Logs
- 5.12 Running Multiple MySQL Servers on the Same Machine
- 5.13 The MySQL Query Cache
- 6 Replication
- 7 Optimization
- 8 Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Data Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 Storage Engines and Table Types
- 15 MySQL Cluster
- 16 Spatial Extensions
- 17 Stored Procedures and Functions
- 18 Triggers
- 19 Views
- 20 The INFORMATION_SCHEMA Database
- 21 Precision Math
- 22 APIs and Libraries
- 23 Connectors
- 24 Extending MySQL
- A MySQL 5.0 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Enterprise Release Notes
- D MySQL Community Server Enhancements and Release Notes
- E MySQL Change History
- F Limits and Restrictions
- G Licenses
- H Credits
- Index
Table of Contents
- 5.1. Overview of Server-Side Programs
- 5.2. mysqld — The MySQL Server
- 5.3. MySQL Server Startup Programs
- 5.4. mysqlmanager — The MySQL Instance Manager
- 5.4.1. MySQL Instance Manager Command Options
- 5.4.2. MySQL Instance Manager Configuration Files
- 5.4.3. Starting the MySQL Server with MySQL Instance Manager
- 5.4.4. Instance Manager User and Password Management
- 5.4.5. MySQL Server Instance Status Monitoring
- 5.4.6. Connecting to MySQL Instance Manager
- 5.4.7. MySQL Instance Manager Commands
- 5.5. Installation-Related Programs
- 5.5.1. comp_err — Compile MySQL Error Message File
- 5.5.2. make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- 5.5.3. make_win_src_distribution — Create Source Distribution for Windows
- 5.5.4. mysql_fix_privilege_tables — Upgrade MySQL System Tables
- 5.5.5. mysql_install_db — MySQL Data Directory Initialization Script
- 5.5.6. mysql_secure_installation — Improve MySQL Installation Security
- 5.5.7. mysql_tzinfo_to_sql — Load the Time Zone Tables
- 5.5.8. mysql_upgrade — Check Tables for MySQL Upgrade
- 5.6. General Security Issues
- 5.7. The MySQL Access Privilege System
- 5.7.1. What the Privilege System Does
- 5.7.2. How the Privilege System Works
- 5.7.3. Privileges Provided by MySQL
- 5.7.4. Connecting to the MySQL Server
- 5.7.5. Access Control, Stage 1: Connection Verification
- 5.7.6. Access Control, Stage 2: Request Verification
- 5.7.7. When Privilege Changes Take Effect
- 5.7.8. Causes of
Access deniedErrors - 5.7.9. Password Hashing as of MySQL 4.1
- 5.8. MySQL User Account Management
- 5.9. Backup and Recovery
- 5.10. MySQL Localization and International Usage
- 5.10.1. The Character Set Used for Data and Sorting
- 5.10.2. Setting the Error Message Language
- 5.10.3. Adding a New Character Set
- 5.10.4. The Character Definition Arrays
- 5.10.5. String Collating Support
- 5.10.6. Multi-Byte Character Support
- 5.10.7. Problems With Character Sets
- 5.10.8. MySQL Server Time Zone Support
- 5.10.9. MySQL Server Locale Support
- 5.11. MySQL Server Logs
- 5.12. Running Multiple MySQL Servers on the Same Machine
- 5.13. The MySQL Query Cache
This chapter covers topics that deal with administering a MySQL installation:
Configuring the server
Managing user accounts
Performing backups
The server log files
The query cache
User Comments
Add your own comment.