:: DEVELOPER ZONE
MySQL Reference Manual :: 5 Database Administration
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 5.1 The MySQL Server and Server Startup Scripts
- 5.2 The MySQL Instance Manager
- 5.3 Configuring the MySQL Server
- 5.4 The MySQL Server Shutdown Process
- 5.5 General Security Issues
- 5.6 The MySQL Access Privilege System
- 5.7 MySQL User Account Management
- 5.8 Disaster Prevention and Recovery
- 5.9 MySQL Localization and International Usage
- 5.10 The MySQL Log Files
- 5.11 Running Multiple MySQL Servers on the Same Machine
- 5.12 The MySQL Query Cache
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 5.1. The MySQL Server and Server Startup Scripts
- 5.2. The MySQL Instance Manager
- 5.3. Configuring the MySQL Server
- 5.4. The MySQL Server Shutdown Process
- 5.5. General Security Issues
- 5.6. The MySQL Access Privilege System
- 5.6.1. What the Privilege System Does
- 5.6.2. How the Privilege System Works
- 5.6.3. Privileges Provided by MySQL
- 5.6.4. Connecting to the MySQL Server
- 5.6.5. Access Control, Stage 1: Connection Verification
- 5.6.6. Access Control, Stage 2: Request Verification
- 5.6.7. When Privilege Changes Take Effect
- 5.6.8. Causes of
Access deniedErrors - 5.6.9. Password Hashing in MySQL 4.1
- 5.7. MySQL User Account Management
- 5.8. Disaster Prevention and Recovery
- 5.9. MySQL Localization and International Usage
- 5.9.1. The Character Set Used for Data and Sorting
- 5.9.2. Setting the Error Message Language
- 5.9.3. Adding a New Character Set
- 5.9.4. The Character Definition Arrays
- 5.9.5. String Collating Support
- 5.9.6. Multi-Byte Character Support
- 5.9.7. Problems With Character Sets
- 5.9.8. MySQL Server Time Zone Support
- 5.10. The MySQL Log Files
- 5.11. Running Multiple MySQL Servers on the Same Machine
- 5.12. The MySQL Query Cache
This chapter covers topics that deal with administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.